SUMMARY

• Around 10 years of IT experience in Data Warehousing wif emphasis on Business Requirements, Analysis, Application Design, Development, Testing, Implementation of Data Warehouse and Data Mart systems and participated in all phases of SDLC (Software Development Life Cycle).
• Skilled in Data Integration, Data Analysis, and ability to translate business logic into ETL processes and well versed in designing / developing ETL solutions for DWH applications using ETL technologies.
• Conversant in writing SQL queries and experience wif various databases and good knowledge of DWH concepts, like Star and Snowflake schemas, SCD, OLAP, OLTP, De - normalization / Normalization.
• Experience in Data Modelling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing Erwin diagrams, analysing data sources and creating interface documents. Used Reverse Engineering approach to redefine entities, relationships, and attributes in the data model as per new specifications in Erwin after analysing the database systems currently in use.
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools) worked on Azure suite: Azure MySQL Database, Azure Data Factory (ADF) V2, Azure key Vault, Azure Blob Storage, Azure Search, Azure App Service, Azure data Platform Services.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities wif high level of adaptability.

TECHNICAL SKILL SET:

ETL Technologies: Informatica PowerCenter 10.2/10.1/9.x, Azure Data Factory

Databases: MySQL, IBM-DB2, Oracle 10g/9i, Teradata15, SQL Server 2008/2005

BI Tools: OBIEE 11g/10gLanguages/Programming SQL, PL/SQL

Others: WinScp, Toad, Tectia, GitHub, Confluence, Erwin

Operating System: Unix/Linux, Windows Platform

PROFESSIONAL EXPERIENCE

Confidential - Columbia, MD

Sr. Informatica Developer

Responsibilities:

• Co-ordination wif business clients and subject matter experts (SMEs) to get functional expertise and converted them into technical design.
• Informatica developments and/or enhancements by creating new mappings and/or making changes to the existing mappings to transform and load the data from/into various systems as per the business requirements.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, and Router, Lookup (Connected and Unconnected), Filter Update Strategy transformations and Re-usable transformations.
• Implemented incremental/delta loads wif the halp of various concepts like mapping variable, mapping parameter and parameter table concept.
• Tuning of the ETL objects by determining the bottlenecks at various points like targets, sources, mappings, sessions. dis led to a better session performance.
• Defined Mapping parameters, variables, and Session parameters according to the requirements to execute the workflows.
• Worked wif session logs, Informatica Debugger and Performance logs for error handling failed sessions.
• Participated in data model reviews wif internal data architect, business analysts, and business users wif explanation of the data model to make sure it is in-line wif business requirements.
• Creating and validating the test scenarios according to business requirements for user acceptance and system testing.
• Deployment of Informatica objects from development to test and tan to production environment.
• Documented the entire process for future maintenance and support.
• Participated in peer-reviews of team members.

Environment: menformatica 10.2, UNIX Shell Scripts, SQL, Oracle, GitHub, Confluence.

Confidential, Elkridge, MD

Sr. Informatica ETL Developer / Analyst

Responsibilities:

• Performing requirement gathering analysis design development testing implementation support and maintenance phases of Data Integration Projects.
• Assisted in creating the ETL source to Target specification documents by understanding the business requirements.
• Developed Informatica mappings that perform ETL process of source data into target systems using various transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, Lookup (Connected and Unconnected), Rank, Joiner, Expression and update strategy to meet business logic in the mappings.
• Developed Informatica mappings for Incremental loads and Slowly Changing Dimension (SCD) for Type me and II to overwritten / preserve historical data as per the business requirements.
• Identified bottlenecks in the ETL mappings and tuned accordingly to improve the performance of the data throughput of the ETLs.
• Used Debugger utility of the Informatica Designer tool to check the errors in the mapping and made appropriate changes to generate the required results.
• Worked on - Caches like Persistent, Static, Dynamic, Data and Index to improve the performance of the transformations.
• Involved in creating Azure storage account and created Azure Data Factory and Azure blob storage container.
• Worked extensively wif Azure Data factory to transform and Migrate data from Legacy systems to Azure MySQL.
• Created and implemented Azure Data Factory Pipeline for data Migration.
• Created Datasets for source and Destination databases and Parameterized connections.
• Used different important activities in Data Factory like Copy Data, Get Metadata, For Each, Lookup, Set Variable for the data migration.
• Declared parameters and variables to be able to copy data to multiple tables in a single pipeline.
• Worked wif DBA’s to develop the Data Model according to user requirements.
• Tested all the Data warehouse ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Participated in code reviews of the team members.

Environment: Informatica 10.2/10.1, Informatica MDM 10.2, Azure Data Factory, Azure MySQL, IBM-DB2, Erwin, UNIX Shell Scripts, SQL, GitHub, Confluence, Oracle.

Confidential - Southfield, MI

Sr. Informatica Developer

Responsibilities:

• Involved in the analysis, design and development of the entire interface is using Informatica PowerCenter tool.
• Modified existing / developed new complex Informatica mappings to extract the data according to the guidelines provided by the business users and populate the data into Target Systems.
• Created mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Joiner, Aggregator, Update Strategy, Filter, Router, Rank and Sorter transformations.
• Worked on Mapping Variables and Parameters, Workflow Variables and Session Parameters.
• Implemented different tasks in Workflows like sessions, events raise, event wait, decision mail, command, worklets, assignment, timer and scheduling of the workflow.
• Extensively worked on PowerCenter Designer tools like Source Analyser, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per the business requirements.
• Used Debugger wifin the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Participated in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Involved in implementing UNIX shell scripts and scheduling Informatica jobs.
• Monitored all the sessions that are scheduled and involved in debugging the Mappings that failed.
• Involved in creating custom reports / Ad-hoc queries using OBIEE answers and assigning them to application specific dashboards and developed different types of reports (Pivot, Charts and Tabular) using global and local filters.

Environment: Informatica PowerCenter 10.1/9.6, Teradata, Oracle 11g, UNIX, SQL, WINSCP, Toad, OBIEE.

Confidential - Overland Park City, Kansas

Informatica Developer

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Worked on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, sequence generator and joiner.
• Actively involved in Performance improvements of Mapping and Sessions and fine-tuned all transformations.
• Designed mappings for incremental loads for slowly changing Dimension (SCD) Type me and II.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables, and dynamic Cache.
• Worked wif Business Intelligence leadership team to develop and enhance Data Quality development process to meet the needs of the business and reduce risk factors.
• Optimized the mappings and implemented the complex business rules by creating re-usable transformations and Mapplets.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Involved in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance, Oracle.
• Responsible for identifying bugs in existing mappings by analysing data flow, evaluating transformations and fixing bugs.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Code walks through wif team members.

Environment: Informatica PowerCenter 9.5, Oracle, SQL, PL/SQL, UNIX, OBIEE

Confidential

Software Developer

Responsibilities:

• Involved in the analysis, design and development of the entire interface’s using Informatica PowerCenter tool.
• Developed Informatica mappings to transform data as per Business Rules and load it into target database.
• Responsible for developing complex mapping, sessions and workflows based on the technical specs.
• Modified existing mappings for enhancements of new business requirements mappings to load into staging tables and tan to target tables in EDW.
• Created sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Testing and debugging of all ETL objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Responsible for monitoring all the sessions that are scheduled and involved in debugging the Mappings that failed.
• Written complex SQL queries to pull the required information from database using Oracle PL/SQL and tuning SQL queries for better performance.
• Involved in Informatica peer review meetings.

Environment: Informatica PowerCenter 9.1, Oracle, SQL Server, IBM-DB2, SQL, PL/SQL. Visio