SUMMARY

• Around 9 years of experience in ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center, IICS, AWS.
• Experienced Data Engineer in ingesting data into AWS S3 data lake using IICS/Informatica Power Center from external source files.
• Worked on Power Center client tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created various mappings using transformations like Aggregator, Source Qualifier, and Connected/Unconnected lookup, Update Strategy, Joiner, Filter and Router Transformations.
• Integration of various data sources like Oracle, SQL Server, Flat Files, into Data Warehouse and also experienced in Data Cleansing and Data Analysis.
• Very good experience in upgrading the Informatica 9.6.1 to 10.1.1.
• Actively involved in preparation of ETL coding standards and checklists, code reviews, working with business users on UAT test scenarios
• Design, develop and customize mappings/workflows for incremental load using Informatica Powercenter.
• Have worked to load and extract data from AWS using IICS AWS connectors for S3.
• Design & development of Teredata Informatica BDM mappings in Hive mode for large volumes of INSERT/UPDATE
• Created Informatica workflow and session parameter files for daily & delta loads
• Involved developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Performance Tuning for targets, mappings and sessions, Task Automation using UNIX Shell Scripts, Job scheduling and Communicating with Server using pmcmd.
• Provided data matching, data cleansing, exception handling, reporting and monitoring features to the data warehouse.
• Collecting and analyzing user’s requirements for new reports in Data Warehouse
• Design of database objects and new ETL loads to user’s requirements. This includes table and indexes design, writing triggers.
• Performance tuning and data sampling for Dev environment.
• Implementations, customizations, configurations and documentation for major business applications including Data Warehouses and Oracle Applications.
• Provide on - call rotational support including troubleshooting and issue resolution on priority
• Documented the best practices for Development and administration.
• Knowledge in Informatica Administration including Installation and upgrade, Configuration, Maintenance and Troubleshooting.
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner

TECHNICAL SKILLS:

Operating System: RedHat Enterprise Linux, Windows 98, XP, 7 and 10

Integration Tools: Informatica 10.2/10.1/9.6/ 9.5 Power Centre, Informatica Intelligent Cloud Services

Reporting Tools: Tableau

Language: Linux Bash scripting

Database: MS SQL Server, Oracle, PostgreSQL, Netezza, Snowflake

Cloud Technology: Amazon S3, Snowflake

Scheduling Tools: Autosys

Modeling Tools: MS Visio 2010/2007, Erwin

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Developer

Responsibilities:

• Confidential has a legacy system called SIS (Student information System) which is on Universe, Data team is responsible to build integration to get data from SIS to new snow flake DB application.
• Created complex Informatica mappings using Unconnected/connected Lookup, joiner, Rank, Source Qualifier, Sorter, Teradata expression and Router transformations to extract, transform and loaded data to SIS.
• Worked on defects and change requests and Production Support issues.
• Developed Informatica mappings, reusable sessions and master workflows.
• Extensive use of AWS CLI to load and extract data out of AWS S3.
• Knowledge of. Snowflake Database, Schema and Table structures.
• Experience in using Snowflake Clone and Time Travel.
• Have worked on IICS mappings to load data to Snowflake Data warehouse from on-premise DB2 database. And also, from flat files using both normal mapping task.
• Created Reconciliation queries and balancing queries to validate source and target data based on business Scenarios.
• Design reusable mapplets to use in different mappings
• Worked on optimizing performance of various long running queries and mappings.
• Reviewed ETL mappings, reconciliation and balancing queries and other deliverables to ensure that the standards and best practices are followed.
• Worked with multiple functional area SMEs to understand the requirement and help them to solution the requirement.
• Experience in Agile methodology- Scrum.
• Experience in working on end-to-end projects starting from Requirement gathering till Production support.

Environment: Informatica 10.1.1,Tableau Desktop 8.x, DB2 UDB, UNIX, Unix Shell scripts, IICS, AWS,S3, Snowflake

Confidential, Durham, NC

Informatica Developer

Responsibilities:

• We are working on 12 source systems and to bring the data into target which is both Netezza and Hive. Project is a suite of tools used for planning and tracking the health of an Initiative/project. Data collection and reporting tool that enabled over 100 teams to enter estimates and provide senior management with near real-time portfolio level reporting. Reduced planning process cycle time by 2 months, allowing teams to focus on delivery instead of planning.
• Developed incremental mappings using Informatica Developer client and deploy the applications.
• Creating the Hive table and loading the data into Hive tables using Informatica.
• Creating the workflow and deploy the workflow to data integration service to run the workflow.
• Create the application and deploy the application to data integration services.
• Developed the mapping by using MAV (mapping architecture Visio).
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Scheduled and facilitated all scrum ceremonies including Daily Stand-up meetings, Scrum meetings, Retrospectives and Sprint Planning meetings
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members to ensure that project deadlines are met at all times.
• Developed test cases and test plans to complete the unit testing. Support System testing.
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Provided end user training and Production System Support.
• Used various transformations like Source qualifier, expression, joiner, router, and filter.

Environment: Informatica BDM 9.6.1,Informatica PowerCenter Teredata 9.6.1/10.1, Netezza, Hive, SQL Server 2008/2005, MySQL, Linux Scripts, SQL server Management Studio and XML

Confidential, Ashburn, VA

Informatica Developer

Responsibilities:

• This project was geared towards delivering a business intelligence solution by redesigning legacy EDW and replacing it with new and enhanced Enterprise data warehouse which integrates data from multiple source systems, adheres to established governance standards, provides auditing capabilities an delivers business value. Systems supports enhanced and timely reporting capabilities to meet new SLOs and user expectations.
• Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple systems.
• Performed requirements gathering, developed analysis & Design document(A&D), developed project timeline.
• Created UTP, UTR and Analysis & Design document.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Developed mappings in multiple schema data bases to load the incremental data load into dimensions.
• Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Sequence Generator and Joiner transformations.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created, launched & scheduled sessions and batches using Power Centre workflow Manager.
• Used Connected and Unconnected lookups in various mappings.
• Scheduled jobs using tools such as Autosys.
• Analysed the session and error logs for troubleshooting mappings and sessions.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data. n-call rotational production support including troubleshooting and issue resolution on priority

Environment: Informatica Power Center 9.6, SQL, Oracle 10g, Teradata, SQL Server 2008/12, Windows 2000, UNIX, Shell Scripting, PL/SQL, TOAD 11.0, Autosys JIL Scripting.

SQL Developer

Confidential

Responsibilities:

• Client Onboarding, Reporting systems, Regulatory reporting Sales and Marketing systems and business process. Supporting the regulatory reports like Monthly, Quarterly and Yearly, Such as PMIR, QIR and DOL. Supporting Business application PYCIS.
• ETL Developer, Design and development of various costs in to dimension tables and fact tables.
• Creation of new mappings to load history data and modification of existing regular mappings.
• Review & understanding existing mappings & workflows, Identifying Dataflow testing them and dealing with performance issues
• Prepare complex SQL to fulfill the technical requirements
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Developed various mapping and session using Informatica Power center for data loading.
• Performed testing as per UTCs
• Testing and debugging of code

Environment: Informatica Power Center8.6/, SQL Server 2008/2005, Oracle9i, PL/SQL, Windows, Flat flies