Sr. ETL/Informatica Developer Resume

SUMMARY

14 years of experience in IT Industry
9 years of experience in the field of Data warehousing/BI
Hands on experience in ETL design and development using Informatica Tools
Ease at various stages of Software Development Life Cycle (SDLC)
Worked in Re - insurance, Life Sciences and Financial services & Insurance Sectors

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6/9.1/8.6/8.1/7.1/5.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager, Informatica Data Quality and Informatica Power Exchange)

Databases: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2016, 2012, DB2 v8.1

Data Modeling Tools: MS Visio and Erwin

Languages: SQL, PL/SQL, UNIX Scripting, COBOL, JCL, Windows Batch scripting

Scheduling Tools: Autosys, Cybermation, CA-7

Operating Systems: Windows, UNIX, MS-DOS, OS-390

Office Tools: MS Access and MS Excel 2016

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. ETL/Informatica Developer

Responsibilities:

Worked as a Senior Informatica Developer in a data warehousing project
Development of ETL components for loading facts and dimension data using Infa 9.1/9.6
Responsibility includes requirement gathering, documentation, designing, development, unit testing and providing production support for the implemented components
Extract the data from actuarial system and build the dashboard for the business users using ETL Tools.
Used various transformations like Router, Expression, Update Strategy, Joiner, Stored Procedure, lookup, Normalizer and Union to develop robust mappings in the Infa Designer
Developed mapping parameters and variables to support SQL override
Created mapplets to use them in different mappings
Developed mappings to load into staging tables and then to Dimensions and Facts
Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
Modified existing mappings for enhancements of new business requirements
Performance Tuned Sources, Mapping, Transformation and Targets to resolve the bottlenecks

Confidential

Sr. ETL/Informatica Developer

Responsibilities:

Worked as a Informatica Developer in a data warehousing project
Extracted data from Flat files, Oracle, SQL and DB2 into the Operational Data Source (ODS) and the data from Operational Data Source was extracted, transformed and applied business logic to load them in the Global Data Warehouse Using Informatica PowerCenter 8.6 tools
Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
Used various transformations like Router, Expression, Update Strategy, Joiner, Stored Procedure, lookup and Union to develop robust mappings in the Informatica Designer
Developed mapping parameters and variables to support SQL override
Created mapplets, sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
Modified existing mappings for enhancements of new business requirements
Used Debugger to test the mappings and fixed the bugs
Involved in Performance tuning at source, target, mappings, sessions, and system levels
Prepared migration document to move the mappings from development to testing and then to production repositories

Confidential

ETL/Informatica Developer

Responsibilities:

Worked as a Informatica Developer in Informatica 5.1 to 8.1 upgrade project
Worked on complex Source Qualifier queries, Pre-& Post SQL queries in the Target
Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow
Extensively used workflow variables, mapping parameters and mapping variables.
Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
Implemented Informatica recommendations, methodologies and best practices.
Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
Involved in Unit, Integration, System, and Performance testing levels.
Written documentation to describe program development, logic, coding, testing, changes and corrections.
Migrated the code into QA (Testing) and supported QA team and UAT (User).
Created detailed Unit Test Document with all possible Test cases/Scripts.
Conducted code reviews developed by my team mates before moving the code into QA.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship