Senior ETL/Informatica Developer Resume

SUMMARY

9 years of Professional IT Experience on various technical platforms and in different functional domains with 8+ years of extensive experience in Data warehousing using ETL Tool Informatica Power Center with multiple sources like Oracle, Teradata, SQL Server, Mainframe, XML etc.
Hands on experience with Informatica administration activities.
Experience of leading and managing mid - size team and coordination of Onsite-Offshore team.
Experience in Development, Enhancement, Support and migration projects.
Experience in different data warehousing approaches and architectures.
Experience in different project methodologies (SDLC) like Agile / Waterfall model.
Technically competent and result-oriented with strong problem solving skills.
Innovative in Approach, Enjoys learning new methods and ideas and putting them into daily practices.

TECHNICAL SKILLS

ETL: Informatica Power Center 10 / 9 / 8. SQL Server Integration Services (SSIS).

Database: Oracle, Teradata, MS SQL Server, DB2.

Programming: Oracle PL/SQL, UNIX Scripting, XML.

Data Modeling: Dimensional Modeling, Relational Modeling.

Applications/Tools: SQL Developer, MS Project, Toad, Jenkins, GitHub, IBM uDeploy, MS Office.

Defect & Task Tracking: JIRA, TFS, Rally, HP ALM (Quality Center).

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL/Informatica Developer

Responsibilities:

Contribute in requirements elicitation, analysis and design.
Providing scope, resource and time estimates for projects presented to Client.
Perform data profiling & cleansing by using Informatica Data Quality (IDQ).
Support activities related to implementation and transition.
Interface with internal team and key stakeholders.
Participating in Knowledge Management activities.
Performance tuning of ETL and DB code.
Perform development & enhancement activities.
Developed oracle pl/sql packages to load data by using informatica stored procedure transformation.
Perform process improvement and automation activities.
Perform code peer reviews.
Responsible for trainings, knowledge transfer and other team activities.

Confidential

Senior ETL/Informatica Developer

Responsibilities:

Created the design and technical specifications for the ETL process of the project.
Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
Implemented various Performance Tuning techniques.
Used PMCMD command to run workflows from command line interface.
Worked with UNIX shell scripts extensively for job execution and automation.
Migration of code from development to Test and upon validation to Pre-Production and Production environments.
Extensively worked on complex mappings which involved slowly changing dimensions.

Confidential

Senior ETL/Informatica Developer

Responsibilities:

Interacted with business analysts & end users to gather the business requirements by attending regular meetings with the business community.
Prepared ETL detail design with field - to-field mappings.
Developed naming convention document for various component of Informatica.
Involved in creation of test plan and test cases for testing the enhanced functionality.
Performed data profiling & cleansing by using IDQ and migrated objects from IDQ to PowerCenter.
Involved in development & documentation to describe program development, logic, coding, testing, and any changes and corrections.
Involved in logging defects in JIRA and monitor the progress until it goes to UAT environment.
Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.