SUMMARY:

• 10+ years of IT professional experience in Data Analysis, Design, Modeling, Data Integration, Development, Testing Implementation and Support of Data Warehousing applications in banking and finance domain.
• Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter v 8.6/ 9.6/ 10.1/10.2 , Oracle (SQL, PL/SQL), Teradata, UNIX, Linux, Scripting, Mainframes, VSAM and COBOL.
• Used Waterfall and Agile Models for Software development lifecycle (SDLC) from requirements gathering through development and support for financial institution using Informatica PowerCenter, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved in creating data maps for mainframe datasets using Informatica Power Exchange 9.1.
• Knowledge of data warehousing techniques like Star/ Snowflake schema, Facts, Dimensions, Slowly changing dimension, OLTP/ OLAP, Data Integration and other ETL methodologies.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, DB2 and Flat Files.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, router, Expression, Lookup, Aggregator, Sorter, Update Strategy, Sequence generator and stored procedure transformations.
• Experienced with advanced Informatica concepts like Session Partitioning, High Availability, Push Down Optimization, Concurrent workflows etc.
• Experience in UNIX & Linux working environment, writing shell scripts for Informatica pre & post session operations.
• Experience in scheduling the batch jobs using Informatica Scheduler, Autosys and CA7 scheduling tools.
• Experience of handling monthly and quarterly end - to-end implementations.
• Basic knowledge on Big Data Hadoop, Informatica Cloud & Salesforce technology.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter v 8.6/ 9.6/ 10.1/10.2 , Powerexchange 9.1, Informatica Data Quality 10.2, Informatica Cloud

Database: Oracle 11g, MS SQL Server 2012, PL/SQL, Teradata

Languages: PL/SQL, Unix & Linux Shell Scripting

Scheduling Tools: Autosys, CA7, Control-M

Incident Management: Service Center, Infoman, Service Now

Other Tools: Oracle SQL Developer, Toad 11, Teradata Studio 15.10, Teradata Unity Datamover, Teradata Viewpoint, Teradata SQL Assistant, Putty, WinScp,WS-FTP, Connect Direct, Endeavor, Harvest, Udeploy, Artifact and GIT

PROFESSIONAL EXPERIENCE:

Confidential, Holmdel-NJ

Informatica ETL Developer Lead

Responsibilities:

• Worked with Business Analysts and Client to better understand business requirements, identifying data source, data integration and development strategies.
• Created technical Design documents and ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse using Informatica Powercenter v 10.2.
• Worked on data profiling using Informatica Data Quality v10.2
• Developed simple and complex ETL mappings for populating data from various sources to Data warehouse following the guidelines as per the Source To Target Mapping documents for dataflow in the project.
• Worked with Oracle SQL Developer to export and load data to/from different source systems including flat files.
• Created reusable workflows, sessions and other tasks like event wait, event raise, decision, command and email to run the workflows with the logic embedded in the mappings.
• Improved performance of ETL’s after applying advanced informatica concepts like session partitioning, high availability, concurrent workflows and pushdown optimization.
• Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
• Planned and successfully completed end-to-end implementations for the project.
• Involved in ETL promotion to QA and production environment.
• Involved in ETL code reviews for compliance with standards.
• Used Informatica, Control-M scheduler to run the Jobs in respective environments.

Environment: Informatica Powercenter v 10.2, Informatica Data Quality 10.2, Oracle 11g, Oracle SQL Developer, Linux/Unix, HP-ALM, Connect Direct, Control-M, Servicenow, Udeploy, Artifact.

Confidential, Cleveland-OH

Informatica ETL Developer Lead, (ETL Architect)

Responsibilities:

• Worked with Business Analysts and Client to better understand business requirements, identifying data source, data integration and development strategies.
• Created technical Design documents and ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse using Informatica Powercenter v9.6 / 10.1.
• Developed simple and complex ETL mappings for populating data from Data warehouse to our EII data mart following the guidelines as per the STM for dataflow in the project.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Created reusable workflows, sessions and other tasks like event wait, event raise, decision, command and email to run the workflows with the logic embedded in the mappings.
• Improved performance of ETL’s after applying advanced informatica concepts like session partitioning, high availability, concurrent workflows and pushdown optimization.
• Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
• Planned and successfully completed end-to-end implementations for the project.
• Involved in ETL promotion to QA and production environment.
• Prepared ETL architecture diagrams.
• Involved in ETL infrastructure server sizing impact analysis.
• Involved in ETL code reviews for compliance with standards.
• Used Informatica, Autosys and CA7 scheduler to run the Jobs in respective environments.

Environment: Informatica Powercenter v9.6/ 10.1, Oracle 9i, SQL Server 2012, Teradata, TOAD, Teradata Studio, UNIX, HP-ALM, Harvest, Connect Direct, Autosys & CA7, Servicenow, Udeploy, Artifact, GIT.

Confidential, Cleveland - OH

Senior Informatica ETL Developer

Responsibilities:

• Prepared a detailed code changes document as per AIX environment after analyzing the Informatica ETL components in Solaris environment.
• Worked on data integration of different sources like Oracle, SQL Server, DB2 UDB Mainframes and flat files.
• Modified numerous complex Informatica Mappings, Mapplets and reusable transformations using various transformations like Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Prepared datamaps for mainframe files/ datasets using PowerExchange v9.1.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Used Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Designed and developed pre and post session UNIX scripts (Extraction and loading scripts) and batch execution routines using mapping parameter/variable.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Performed Code review to ensure that ETL development / modification was done according to client’s ETL standard and ensured that ETL best practices were followed.
• Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
• Actively participated in end-to-end implementations for the project.
• Used Informatica, Autosys and CA7 scheduler to run the Jobs in respective environments.
• Created CA7 documents in Endevor and Harvest.
• Coordinate with ETL Administration team to setup ETL applications in Informatica AIX environment.
• Coordinate with ETL release management team to promote code in QA and production environments.

Environment: Informatica Powercenter v8.6/ 9.1, Oracle, SQL Server 2012, TOAD, UNIX, Harvest, Autosys & CA7.

Confidential, Cleveland - OH

Informatica ETL Developer

Responsibilities:

• Develop and test Informatica mappings for the different stages of ETL.
• Load data into staging area and data warehouse using ETL process.
• Design and develop ETL jobs for transforming and loading various targets using Informatica, database scripts.
• Develop mapping to connect to different sources like Mainframes files, DB2 tables, XMLs, flat files and FTP sources.
• Develop reusable transformation.
• Extensively used all Informatica capabilities such as Target override, connected /unconnected and persistent lookups.
• Provide support for design of experiments, data analysis and result interpretation related to continuous improvement projects.
• Worked on Designer tools like Source Analyzer, Transformation developer, Mapplet designer, Mapping designer.
• Extensively worked on Joiner transformations like normal join, full outer join, master outer join and detail outer join.
• Used Debugger wizard to troubleshoot data and error conditions.
• Used Power Exchange to create datamaps for Mainframes source files.

Environment: Informatica Powercenter v8.6, Oracle 10g, PL/SQL, TOAD, UNIX, Power Exchange, JCL, COBOL, Serena Changeman, Harvest, Autosys & CA7.