Module designer & ETL Developer Resume

PROFESSIONAL SUMMARY:

A diversified technical expertise with more than 8.6 years of overall experience.
Almost 8 years of experience as Informatica ETL Developer in Data warehousing, data Integration in different domains.
8 months of experience in Core Java.
Cloudera Hadoop Developer (CCDH) and Informatica Developer Certified.
Decent experience in designing of data warehouse and data Integration modules in life science and financial domains with secured prototype.
Strong knowledge of Data Warehousing concepts, HDFS, Map Reduce.
Hands on experience in writing Pig Script, HiveQL, UNIX Shell and Perl Script
Responsible for keeping track of the quality assets and progress throughout the releases and test cycles.
Good Technical and Analytical abilities to approach the problem.
Experience in effective client communication and inter team co - ordination.
Excellent communication, interpersonal and presentation skills.
Ability to work under pressure and mission-critical environments, having initiative to work on different technologies and platforms.

TECHNICAL SKILLS:

Business Intelligence: Informatica 9.5/8.6/8.1/7.1, Informatica WebService

BigData Technologies: Hadoop (HDFS, Map-Reduce 1 & 2), Pig, Hive, Sqoop, flume

Languages: Java, MapReduce, Hive, SQL, PL/SQL

Scripting language: Pig, Perl & Shell Script

Databases: Oracle 9i & 10g, SQL Server 2008

Trained on: Spark, Scala, Talend, OBIEE 10g, OBIA, Teradata

PROFESSIONAL EXPERIENCE:

Confidential

Module designer & ETL Developer

Responsibilities:

Gathering functional requirements from Business Analyst and designing the module with robust error-handling process
Designing the technical part of the module to integrate Informatica with WebService and Salesforce
Coordinated with salesforce & WebService team to creating end-to-end field mapping
Worked as ETL Developer to build the module and schedule daily/hourly jobs in control-M
Taken end-to-end responsibility of the module.

Confidential

Module designer & Developer Team Lead

Responsibilities:

Leading the team acting as L3/enhancement support for UBS GRW.
Designing the technical architecture of the module.
Also worked as Informatica Developer to build the module.
Taking end-to-end responsibility for the module.
Created shell scripting to achieve file house-keeping mechanism.
Created script to do encryption/decryption of file before SFTP to ADP third party vendor.

Confidential

Team Lead and ETL Developer

Responsibilities:

Leading the team acting as L3/enhancement support for UBS GRW.
Working with the Frontline Support team to resolve incidents.
Creating optimized mappings and workflows to populate warehouse tables.
Involved in deploying code across the environment.
Creating shell scripting to achieve file house-keeping mechanism.
Involved in creating Autosys JIL script to schedule Autosys jobs in UAT and production environment.
Guiding juniors to achieve client requirement right in time.
Taking end-to-end responsibility of all modules.
Also supporting production support team in case of any production issue.

Confidential

Business Intelligence

Responsibilities:

Analysis of system specification document.
Creation of source to target mapping document to load data as required.
Create unit test cases for different modules such as Affiliation, Trace, FOCUS (Integration Load) and documented.
Created mapplets to perform Add, Change and Delete detection in the modules.
Worked on Shell script to do file FTP and triggering the informatica workflows.

Confidential

ETL Developer

Responsibilities:

Extraction, Transformation and Loading of the data Using Informatica
Used relational sources and flat files to populate the data mart
Involved in the development of informatica mappings
Created informatica mappings to load the data mart and monitored them. The mappings involved extensive use of operators like Aggregator, Filter, Expression Joiner, Sequence Generator.

Confidential

Business Intelligence

Responsibilities:

Extraction, Transformation and loading of data from flat file, Oracle, SQL server 2005 sources to oracle database.
Extensively used different transformations like source qualifier, filter, aggregator, expression, connected and unconnected lookup, sequence generator, router and update strategy.
Documentations of mappings as per standards.
Involved in the code review and preparing the code review document.