SUMMARY

• ETL Informatica expert with 5+ years of IT experience. Operating as an ETL developer in multiple projects and skilled in analysis, design, testing, UAT and implementation with data warehousing applications.
• Good experience in Informatica PowerCenter 10.2, 9.6.1, 9.1, along with a strong background ETL skill for Data warehousing using Informatica.
• Extensive experience in developing ETL applications and statistical analysis of data on databases ORACLE 10g/11g, Teradata 15, PostgreSQL and SQL Server 2016.
• Have ability to write and interpret complex SQL statements and good in SQL optimization and performance tuning
• Implemented Change Data Capture (Confidential) with Informatica Power Exchange.
• Extensively worked on Informatica Power center transformations as well like Expression, Joiner, Sorter, Filter, Router and other transformations as required.
• Good in Data Warehouse Concepts like Dimension Tables, Fact tables, Slowly Changing Dimensions, DataMart’s and Dimensional modeling schemas.
• Experience in Data modeling; Dimensional modeling and E - R Modeling and OLTP AND OLAP in Data Analysis. Very familiar with SCD1 and SCD2 in snowflake schema and star schema.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power center components.
• Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Expertise on Agile Software Development process.

TECHNICAL SKILLS:

ETL

Informatica PowerCenter 10.2, 9.6.1, 9.0.1

ETL Scheduling Tools: Control M, ESP

RDBMS: DB2, Oracle 11g/12g, SQL Server 2008/2012, MySQL, PostgreSQL, Teradata 14/15

UNIX: Shell scripting

Operating Systems: Windows, UNIX

Programming Languages: C, C++, PL/SQL

Other Tools: Notepad++, Toad, SQL Navigator, Teradata SQL Assistant, JIRA, Rally

PROFESSIONAL EXPERIENCE

Informatica Developer,

Confidential, Westlake, TX

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for dis data migration project.
• Involved in documentation of Data Mapping & ETL specifications for development from source to target
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into target tables.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer and Transformations.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Leveraged JIRA to create test cases and execution.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Developed Parameter files for passing values to the mappings for each type of client
• Maintained status, defect details in Rally.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Monitored systems and processes to ensure seamless loading of data in time using control M.

Environment: Informatica PowerCenter 10.2, Oracle 11g, PostgreSQL, PL/SQL, UNIX Shell Scripts, Unix, Erwin 9.3, Control M, Teradata 16

Confidential, Menomonee Falls, WI

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, UAT, deployment to production environment.
• Actively involved in interacting with business users to record user requirements.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for dis data migration project.
• Involved in documentation of Data Mapping & ETL specifications for development from source to target.
• Also implemented the change Data Capture (Confidential) while integrating the enterprise data sources.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Maintained naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Tested End to End to verify the failures in the mappings using scripts.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Resolving the tickets based on the priority levels raised by QA team.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.

Environment: Informatica PowerCenter 9.6.1., Teradata 14, Teradata SQL Assistant, Oracle 11g, MySQL, UNIX, Control M, JIRA.

Confidential, Nashville, TN

Responsibilities:

• Collaborated with Business users to collect requirements and prepared ETL technical specifications.
• Worked on Informatica Source Analyzer, designer, Mapping & Mapplet Designer and Transformation Designer.
• Wrote SQL queries for analyzing data, performed data Profiling, prepared Source to target mapping.
• Wrote SQL overrides in source qualifier to filter data according to business requirements.
• Developed Informatica mappings and also in tuning of mappings for better performance.
• Implemented SCD Type 1 and 2 using Informatica mapping
• Participated in deployment planning and in deployment of the system to production.
• Facilitated business user smoke testing of the production system by setting up test data.
• Involved in code review sessions to bring the team’s attention to best practices and to identify areas of improvement.
• Responsible for implementing action items identified during code review sessions focused towards improving data quality and performance.
• Developed sessions and batches to move data at specific intervals and on demand using workflow manager.
• Wrote Unix shell scripts for scheduling Informatica pre/post session operations.
• Created different parameter files and started sessions using these parameter files using pmcmd command to change session parameters, mapping parameters, and variables at runtime.

Environment: Informatica PowerCenter 9.1.1, SQL Server 2008, Oracle 10g, PL/SQL, UNIX, Teradata 14, Cognos 9