SUMMARY:

• Over 7+ years of experience as ETL Developer in Data warehousing projects. Had good exposure to Healthcare, Banking and Life sciences projects. Worked predominantly in Informatica, Oracle, Unix, Teradata, Db2, Crystal reports and SSIS.
• Gathering requirements, creating design document and mapping document. Communicating with plan team to get the business requirements, understand the requirements and raise issues/changes, if necessary. Once the issues are addressed, design document is finalized and approved by business team.
• Design and develop complex ETL (Extract Transform Load) mappings using Informatica. For this process mappings are created which transforms and load history data in data warehouse. Sometimes the business requirement is to load XML data into the data warehousing tables and the necessity is to create complex mapping document for these loads.
• Working on Informatica Designer Tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches. These are all various components of Informatica, which needs to be worked on. Creating source connections, building reusable code, creating shared mapplets, creating sessions and workflows for process execution etc. needs to be done as project activity.
• Analyzing existing system and develop business documentation on change request.
• In some sub project the necessity is to understand existing system, understand and implement the data migration using Informatica. These are some of the things that need to be done as part of project activity.
• Fine tuning existing Informatica mappings for performance optimization.
• Design and development of Unix Shell script to handle pre and post session processes. Unix Scripts are necessary to handle pre and post session processes in Informatica.
• Develop data mining scenarios in support of business requirements.
• Provide scalable solutions to manage large volume imports and implement operational procedure as necessary.
• Involvement in data modelling and data architecture with plan team.
• Determining the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.
• Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
• Collaborate with Metadata Manager and perform tests and provide update to all ETL activities within schedule and provide support to all large data volumes and assist in data processing.
• Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
• Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
• Develop all data warehouse models and prepare reports for all meta data integration into systems and draft all ETL scripts and prepare required reports for all end users.
• Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
• Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
• Handled a team of more than eight members in offshore by assigning ETL tasks to them on daily basis as per project requirements.

TECHNICAL SKILLS:

Operating Systems: Unix, Windows 10, Windows 7 and Windows XP/2000

ETL Tools: Informatica 10x/9x/8x and SSIS SQL server Integration services

Databases: Teradata(v15), Oracle 10g/11g, DB2 and MS SQL

Reporting Tools: Crystal Reports

Scripting Languages: Bash/Korn Shell, Perl

Scheduler Tools: Tivoli Scheduler

Code Review Tools: Platinum code review tool and UNIX scripts

Programming Languages: C#, ASP.NET, VB Excel

Other Utilities: HTML and XML

PROFESSIONAL EXPERIENCE:

Confidential - Pleasanton, CA

Senior Informatica ETL Developer

Responsibilities:

• Worked in Creating Informatica mappings using Flat files as Sources.
• Developed Critical Informatica Mappings to populate data from tables to single Data warehouses.
• Imported Several relational and non-relational sources and targets into informatica power center.
• Worked with flat file sources such as Delimited flat files (Comma delimited, Pipe delimited) and Fixed width flat files.
• Good Knowledge and Experience in creating Informatica objects such as Mappings, Workflows, Mapplets and Worklets.
• Worked on XML sources and XML target files.
• Created Deployment groups and used them in migrating code from lower environments to higher environments.
• Worked on few Perl scripts as a per project requirements and used them in checksum calculations of the records.
• Worked in code migration by using Labelling concept in informatica.
• Have Good knowledge in creating the Informatica mappings that involves Slowly changing dimensions concepts - SCD Types
• Did Performance tuning on the existing code for long running sessions in informatica.
• Resolved defects that are raised in HP Quality center. Have good exposure to Quality Center 10.0 version.
• Worked in Development of Informatica code from the scratch till the production go-live.
• Worked in writing simple to complex Unix scripts in the project for handling several scenarios.
• Experience in writing Unix scripts for file processing - Archival process and Analyzing data.
• Had exposure to Oracle database and DB2 databases, several database objects have been created in databases.
• Worked on preparing complex SQL queries for code validations.
• Have exposure to several flat file scenarios, date-time conversion logics, usage of flat files as lookup transformations.
• Worked on JAVA transformation for splitting the records scenario.
• Have knowledge on Informatica transformations - Normalizer, Transaction control, Rank, HTML and JAVA transformations.
• Worked on both static and dynamic lookup transformations.
• Knowledge in preparing Test data in non-prod environments. Worked as ETL code reviewer in the team and responsible for code deliveries to PROD within SLA.
• Created the Informatica webforms using Tivoli scheduler properly without affecting the run flow.
• Prepared Test case documents, SIT and UAT documents for each piece of code.
• Used Platinum code reviewer tool to validate the informatica code by importing the XML code into the tool by setting up the static and dynamic rules in the tool.
• Created work orders, Incidents and change requests for getting software accesses, in case of any failures in the process, privileges issues, code migrations etc. in BMC remedy tool.
• Worked on RTC (Rational team concert) tool for code migrations of Database, ETL code and Linux code.
• Designed Tables structures based on normalized forms in oracle to enhance the performance. Did performance tuning by framing indexes, partitions and proper written SQL code.

Confidential

Informatica ETL Developer

Responsibilities:

• Worked in Creating Informatica mappings using Flat files as Sources.
• Developed Critical Informatica Mappings to populate data from tables to single Data warehouse.
• Imported Several relational and non-relational sources and targets into informatica power center.
• Worked with flat file sources such as Delimited flat files (Comma delimited, Pipe delimited) and Fixed width flat files.
• Good Knowledge and Experience in creating Informatica objects such as Mappings, Workflows, Mapplets and Worklets.
• Created Deployment groups and used them in migrating code from lower environments to higher environments.
• Worked in code migration by using Labelling concept in informatica.
• Have Good knowledge in creating the Informatica mappings that involves Slowly changing dimensions concepts - SCD Types
• Did Performance tuning on the existing code for long running sessions in informatica.
• Worked in Development of Informatica code from the scratch till the production go-live.
• Worked in writing simple to complex Unix scripts in the project for handling several scenarios.
• Experience in writing Unix scripts for file processing - Archival process and Analyzing data.
• Had exposure to Oracle database and DB2 databases, several database objects have been created in databases.
• Worked on preparing complex SQL queries for code validations.
• Have exposure to several flat file scenarios, date-time conversion logics, usage of flat files as lookup transformations.
• Worked on JAVA transformation for splitting the records scenario.
• Have knowledge on Informatica transformations - Normalizer, Transaction control, Rank, HTML and JAVA transformations.
• Worked on both static and dynamic lookup transformations.
• Knowledge in preparing Test data in non-prod environments. Worked as ETL code reviewer in the team and responsible for code deliveries to PROD within SLA.
• Created the Informatica webforms using Tivoli scheduler properly without affecting the run flow.
• Prepared Test case documents, SIT and UAT documents for each piece of code.
• Used Platinum code reviewer tool to validate the informatica code by importing the XML code into the tool by setting up the static and dynamic rules in the tool.
• Created work orders, Incidents and change requests for getting software accesses, in case of any failures in the process, privileges issues, code migrations etc.
• Created one to one, one to many mappings by using Microsoft Visio templates in informatica power center.

Confidential

ETL / Dot Net Developer / L3 Support Analyst

Responsibilities:

• Worked on Execution of applications and processes that are executed based on Daily, Weekly and Monthly schedules.
• Performed Enhancements in the existing code in Visual Basic code.
• Tested the existing code and migrated it to different versions of Microsoft excel versions.
• Level 3 support has been provided to the applications that are built on C# code.
• Fixed the defects in process of C# and VB excel code.
• Created the ODBC connections to different databases in order to connect to Crystal reports 2008.
• Prepared Standalone reports, cross-tab reports and sub-reports in crystal reports 2008.
• Involved in preparing complex SQL queries to generate the crystal reports in DB2 and oracle.
• Worked in code migration for applications from Excel 2007 to Excel 2010.
• Worked in code migration of C# and ASP.Net code from Visual studio 2008 to Visual studio 2010.
• Involved in creation of several Workorders, Change requests and Incidents in BMC Remedy portal.

Confidential

ETL / Dot Net Developer

Responsibilities:

• Worked on development of C# and ASP.NET code on the data layer and application layer.
• Involved in developing the code in C# for schedulers. Worked in the code for enhancements in windows and Quartz schedulers
• Created the relational Data models, Entity models and several database objects in Microsoft SQL server 2008 R2 version.
• Experience in creating the packages in SSIS Microsoft SQL server integration services ETL tool.
• Created packages in SSIS ETL tool for Extraction of data and Loading of data.
• Developed SSIS packages with different source systems such as relational databases and non-relational Databases (such as files)
• Worked on Visual Studio 2008 and 2010 in the development of three-tier architecture.
• Worked in Preparation of Test data - Data replication by using SQL server wizard tool.
• Involved in preparing Logical solution design documents and Physical solution design documents.
• Developed and Tested the code in provided deadlines to meet SLA.