Senior ETL Developer Resume Madison, WIÂ - Hire IT People

SUMMARY:

Authorized to work in the U.S.
7+ years of IT experience in Analysis, Design, Development, Testing and Implementation of business application systems for healthcare, insurance, manufacturing industries.
7+ years of exceptional Data Warehousing ETL experience of using Informatica PowerCenter 9.x/8.x
Proficient in analysing client - side requirements and translating into technical requirements.
Excellent understanding of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle, Sybase, DB2 and SQL Server using Informatica.
Supervised and mentored new ETL developers as project lead

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.6.1.9.x/8.x., Power Exchange, Metadata Manager

RDBMS: Oracle 11g/10g/9i/8i, DB2, UDB, Sybase, Microsoft SQL Server, MS Access

Data modeling tools: Erwin, MS Visio

Languages: XML, Visual Basic, SQL, Oracle PL/SQL, Shell Scripting.

Operating Systems: Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Solaris, HP-UX, AIX).

BI Tools: Knowledge of Business Objects 5.1/5.0, Crystal Reports 4.x/6.x

Software/Tools: Flat files, MS-Office Suite, Toad, SQL Navigator, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Senior ETL Developer

Responsibilities:

Interacted with Data Governance/Business Analyst for requirement gathering and responsible for the analysis, design, development, testing and implementation of Informatica Mappings & Workflows.
Created Stored Procedures for data transformation purpose.
Tuned Informatica Mappings and Sessions for optimum performance and modified existing mappings for enhancements of new business requirements.
Improvised with DBA's for partitioning, creating indexes on tables used in source queries.
Developed high-level design specification to simple ETL coding and mapping standards.
Assisted with migration of code between environments like DEV, QA, PROD using various methods like folder copy, deployment groups and XML files.
Coordinated among various teams: DBA, UNIX, Ops and QA team in preparation of environment release.
Provided Production on call support for current/coexisting projects and prepared production monitoring and support handbook for ETL Process.

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

Worked with Business Analyst for requirement gathering and responsible for the analysis, design, development, testing and implementation of Informatica Mappings & Workflows.
Worked on hierarchical tables as target to implement hierarchical relationship among data.
Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
Developed sessions using Workflow Manager for loading the data into target Database / flat files.
Named tables and maps that conform to Del Monte standards.
Developed source and target reconciliation queries to test and validate the maps in order to ensure the maps function in accordance to the business rules.
Developed validation queries used to develop reports as specified by the users.
Performed integration and unit testing.
Used Debugger to create debug sessions and break points to test the mappings developed.

Confidential, Jersey City, NJ

ETL Developer

Responsibilities:

Developed an enterprise-wide insurance policy sales data warehouse to analyse the sales of all Insurance policies for the client.
Responsible for coding of mappings and unit testing and integration testing.
Designed and developed UNIX scripts for scheduling the jobs and generating parameter file automatically.
Identified bottlenecks and involved in performance tuning of ETL loads.