Senior ETL Developer Resume

SUMMARY

9+ years of IT experience in Analysis, Design, Development, Testing and Support of Data Warehousing and Data Integration Solutions.
Expertise in Informatica Power Center 10.x/9.x/8.x, IDQ, Oracle, SQL Server, Flat Files, XML, SAP BW and Salesforce.
Complete knowledge of data warehouse methodologies and concepts.
Have extensively worked in developing ETL programs for supporting Data Extraction, transformation and loading using Informatica.
Experienced in working with Project Management, Analysts and Business Teams in Project deliverables.
Involved in design meeting and low - level design preparations.
Extensive experience maintaining Standards, Best Practices, Data Definitions.
Experience with dimensional modeling using star schema and snowflake models.
Extensive experience in using RDBMS technologies like Oracle, SQL Server, Greenplum, Toad 9.7, SQL*Plus
Proficient in Oracle PL/SQL including writing stored procedures, functions, triggers, packages etc.
Expertise with Data cleansing and profiling using Informatica Developer tool.
Experience in CDC implementations using Informatica Power Exchange, Control Tables, and Setmaxvariable and Parameter file approach.
Experience in Data validations, Testing, Job Scheduling and Defect fixing.
Experience working in Agile and waterfall environments.
Actively involved in performance tuning techniques related to Informatica and Oracle.
Strong with relational database design concepts.
Proficient in writing UNIX Shell Scripts.
Knowledge on BI tools Cognos and Spotfire.
Exceptional analytical and problem-solving skills. Team player with the ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS:

Tools: and Technologies:

ETL Tool: Informatica Power Center 10.x/9.x/8.x/7.x, Informatica Developer 9.x, Power Exchange, IDQ

ETL Sources: Oracle 11g/10g/9i, Flat Files, SQL Server, XML, SAP BW, Salesforce

DB Tools: SQL*Plus, TOAD 9.7, Sql Developer, Toad

Development Languages: SQL, PL/SQL, T-SQL, Unix Shell Scripting

Data Bases: Oracle 11g/10g/9i, MySQL, SQL Server, Greenplum

Operating Systems: Windows 98/2000/NT/XP/7/8, UNIX, LinuxBI Tools: Cognos, Spotfire

Scheduling: WLM, Informatica Scheduler, Tidal

Web Technologies: Java, HTML, XML, DHTML, Eclipse

Data Modeling Tools: Erwin, Rational Rose

Others: Query Surge, PL/SQL Developer, PVCS, RFT, MS Office, HP Quality Center, Remedy, Macros

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

Developed Informatica Mappings, sessions and workflows to load data into the warehouse.
Worked with business requirement teams, data modelers and Technical Architects in understanding the requirements and suggested technical improvements.
Worked on slowly changing dimensions, Fact tables and Flat files.
Worked on poc using informatica developer tool for dashboard testing and resolved most of the issues before going to actual development.
Worked on impact analysis and gap analysis on the CTMS source system when moving from on-premise to cloud with version upgrades.
Involved in all phases on project development.
Worked on SQL, PL/SQL stored procedures, triggers, functions etc.
Helped the team in improving coding techniques, Task assignments and issue resolutions.
Helped the Dashboard team in data validation and resolving the issues.
Implementing performance tuning, optimization techniques and better coding practices.
Developed source-target mapping, ETL design documents and coding standards documents.
Created driving and supporting mappings to have data accurately in target.
Worked on shell scripting for ftp files, creating list files, parameter files etc.
Used Power exchange and control tables to pull incremental data.
Worked on IDQ using Informatica developer tool to perform data cleansing and also created LDO’s, Profiles, Rules, mapping and mapplets using Standardization, Labeler and consolidation transformations.
Participated in code reviews, work estimations and task assignments.
Worked on test planning, unit testing, system testing and job scheduling.

Environment: Informatica Power Center, Power Exchange, Oracle, Informatica Developer, PL/SQL, SQL, Tidal, Query Surge, Unix and HP QC.Client: Union Bank, Monterey Park, CA Oct 2014- Mar 2015Role: Senior ETL DeveloperThe project deals with integrating data from various source systems and develop an enterprise data warehouse. Data related to 23 systems will be combined which are in the form of files and tables in the source systems.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship