Senior ETL Developer Resume

SUMMARY:

11+ years of experience in IT industry out of which 8+ years of experience in Data Warehousing, ETL and Data integration.
Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, Deployment and Warranty Support .
Strong at providing production support, strong Customer interaction, presentation and negotiation skills.

TECHNICAL SKILLS:

RDBMS: Teradata, Oracle, DB2 and SQL server.

ETL TOOLS: Informatica PowerCenter 10.x/9.x/8.x, Informatica Cloud, Informatica Developer and BDM.

Scripting Languages: Basic scripting using Python and Windows batch.

Big Data Ecosystems: HDFS and Hive.

Reporting tools:: Debugging Knowledge on Business Objects and Tableau.

Operating Systems: Mac, Unix, Linux and Windows.

Data Modeling/Dimensional modelling: Star schema and Snowflake schema.

Scheduling tools:: Autosys and Zena.

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Senior ETL Developer

Responsibilities:

Application development using ETL tools Informatica PowerCenter, Informatica Cloud, Informatica Developer and Informatica BDM.
Created and Modified various database objects like Tables, Views, Stored Procedures etc.
Performed various database programming tasks such as creation of views, tables, stored procedures and user functions on DB2 and SQL Server .
Integrating cloud applications (like Salesforce) using Informatica Cloud Services (ICS).
Developed Incremental Data Replication and Data Synchronization tasks to move/replicate the data from Salesforce.com to SQL server database.
Developed mappings and workflows using Informatica Developer and BDM to load the data from DB2 (Data warehouse) to HDFS and create Hive tables on top of it.

Confidential, Torrance, CA

Senior ETL Developer

Responsibilities:

Design develop and test ETL solutions including modeling data warehouse metadata and automating data loading processes.
Involving in requirements gathering along with Data Architect and conducting meeting with source teams to understand and analyze the source objects and data.
Created Mappings, Sessions and Workflows in Informatica PowerCenter and BDM and Scheduled the Workflows using Zena scheduler.
Involved in bug fixes and improve ETL performance by performance tuning of targets, sources, mappings and sessions.
Establishes ETL environments according to project requirements.
Design and implement an efficient migration process to move ETL objects from development to test and production environments.
Handled Exceptions during Loads and implemented logic to send valid Exceptions to Users.
Created Hive tables and Developed mappings to load data to Hive tables using Informatica Developer and BDM from DB2 and SQLserver.

Confidential, Sunnyvale, CA

Data Engineer

Responsibilities:

Development, support and maintenance of applications using Informatica, Teradata, Hive, Oracle etc.
Modified various objects like Materialized Views, Stored Procedures, Packages, Functions wherever the change has the impact.
Involved in bug fixes and improve performance by performance tuning of targets, sources, mappings and sessions.
Coordinate with other support groups like Database administrators, System Engineers and Operations to maintain the overall application health and security.
Production Support, major enhancements and maintenance of existing Data warehouse.
Develop and Enhance Teradata BTEQ scripts, SQL scripts and ETL (Informatica) applications.

Confidential

Data and Production support Engineer

Responsibilities:

Development, support and maintenance of applications using Informatica, Teradata, Hive, Oracle, Business objects etc.
UAT plan, Communication with Data Modeling and DBA team and doing production implementation from start to end
Working with business users for gathering business requirements, conducting system analysis and contributing to the design, development and testing of the application(s)
Production Support, major enhancements and maintenance of existing Data warehouse.

Confidential

Programmer

Responsibilities:

Developed the Informatica mappings for loading data into stage and DataMart. Created Mapplets using Mapplet Designer.
Code review and validating the mappings etc. Prepared the unit test cases for unit testing.
As a programmer involved in designing the webpages, backend logic, testing and maintained program for report generation and aiding in project management.
Coordinating with the team and Involved in coding for developing the workflow.
Designing the user interfaces using multiple web technologies.
Develop, groom, coach team members so that they can perform better.
Maintaining the statistics of the data loading process and maintaining the reports.