SUMMARY

• 8Years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration solutions using Informatica Power Center 10.2/9.5/9.1/8.6 , SSIS.
• Proficiency in requirement gathering and data modelling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Working experience on Informatica BDM admin console and Developer console.
• Used Informatica BDM IDQ 10.1.1 (Big Data Management): To inject the data from AWS S3 raw to S3 refine and from refine to Redshift.
• Experience with dimension modelling using Star and Snowflake schemas.
• Have worked on Agile Methodology.
• Design, Development, Testing, and Implementation of ETL processes using Informatica Cloud
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experience in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Hands on experience in working on SQL Server 2005/2008R2/2012/2016 databases, Azure SQL, Azure Data Factory & Azure Data Lake.
• Experience in working with big data Hadoop stack tools like HDFS, HIVE, Pig, Sqoop.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM
• Experience in Installing and Configuring of Informatica MDM Hub Console and Data Director
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM.
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation
• Proficient in Relational Database Management Systems (RDBMS) .
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008, and Teradata.
• Expertise in working with various operational sources like Oracle, Teradata, DB2, SQL Server 2005/2008, Flat files, into a staging area.
• Experience in Informatica PowerCenter 10.2/9.5/9.1/8.6 with Oracle10g/11g.
• Experience in SSIS2012with SQL Server 2005/2008 R2, 2012 .
• Experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience in UNIX Operating System and Shell scripting.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Extensive experience using database tool such as TOAD, SQL *Plus, SQL * Loader
• Excellent Interpersonal Skills with the ability to work with the Team
• Team player, motivated, able to grasp things quickly with analytical and problem-solving skills. Comprehensive technical, oral, written and communication skills.
• Desire to learn new skills, technologies, and adapt to new information demands.
• Experience in production support to resolve critical issues and mingle with team s to ensure successful resolution of the reported incident
• Experience in working as a Technical Coordinator of an Onshore/offshore Model.
• Developed Informatica Mappings to populate the data from oracle OLTP database to oracle and Teradata data warehouse.

TECHNICAL SKILLS

Datawarehouse/ETL Tools: Informatica Power Center 10.2/9.5/9.1/8.6 , Informatica BDM, Informatica Data Quality (IDQ), Data Validation, Informatica Power Exchange 10.2/9.5.1, Azure Data Factory, Azure Data Lake, SSIS 2012, SSRS 2012

Operating Systems: Windows 07/XP/Vista/95/98, UNIX.

Databases: Oracle 12c,11g/10g/9i/8i, Teradata, MS SQL Server, IBM DB2, Sybase.

Languages: SQL, PL/SQL, UNIX, HTML, XML

Methodologies: E-R Modelling, Star Schema, Snowflake Schema

Scheduling Tools: Control M, Tivoli, Autosys

Other Tools: TOAD, SQL *Plus, SQL * Loader, MS Access

PROFESSIONAL EXPERIENCE

Confidential

Informatica ETL Lead Developer

Responsibilities:

• Worked on Various applications as Informatica Power-Exchange CDC, IBM CDC, Informatica IDQ and MDM Developer, Informatica Power Centre, Service Now.
• Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modelling.
• Involved in Informatica upgrade project from Informatica 9.6 to 10.2 version.
• Created Data flow design for ETL’s from Control-M job Scheduling tool.
• Worked on creating multiple Change Management Requests in Service Now.
• Worked closely with business team to finalize on the validation rules that need to be applied outside Informatica ETLs.
• Extensive experience in error handling and problem fixing using Informatica.
• Developed excellent overall software Development life cycle (SDLC) professional skills by working independently and as a team lead to analyse the Functional/ Business requirements and to prepare test plans, test scripts.
• Collaborated onsite teams, interacted and well managed various offshore teams on delivering product to client.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Experience with Power Exchange Navigator handling registration/extraction groups from different Databases (Oracle, DB2, SQL) and performing row tests to check the data.
• Created technical specification documents/runbooks for each ETL codes and overall activities in exhaustive detail listing all technical and business validation rules for Production Go-Live.
• Highly experienced in developing, designing, reviewing, and documenting Informatica work products like Mappings, Mapplet, Shortcuts, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Creating/updating Unix/Linux scripts and creating/updating Control-M, Autosys files for new/existing jobs
• Resolving recurring issues by finding the root cause for permanent fix
• Performing Production support/maintenance activities like code changes, code review, testing, Performance tuning, creating Change Requests and production deployment
• Performed basic Informatica Admin activities like exporting & importing objects, deploying objects to other environments, configuring parameter files, and writing and running scripts to clean -up disk space
• Design, Development, Testing, and Implementation of ETL processes using Informatica Cloud

Environment: Informatica Power Center 10.1/9.6.1, Informatica Power Exchange, Informatica MDM Multi Domain Edition 10.x, SQL Developer Oracle 10g, XML, Flat Files, SQL Developer, PL/SQL, Unix shell scripting, WinSCP, Putty.

Confidential

ETL Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica PowerCenter9.5 for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Creating weekly and monthly reports of production jobs using MS access.
• Production load jobs monitoring and impact analysis on job failures.
• Have configured PowerCenter to load the data to Hive directly without Informatica BDM for less resource intensive jobs.
• Convert the PowerCenter code using the informatica developer to BDM Mappings.
• Ran the workflows on a daily and weekly basis using Tivoli Scheduling tool.
• Production code fixes and act promptly to resume the loads so that jobs meet their SLA’s.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Data analysis as per business team requirement and provide detailed explanation and documenting the insights.
• Prepare weekly Job deck of whole jobs for business team.
• Implemented Slow changing dimensions SCD-1 and SCD-II mappings to upgrade Slowly Changing Dimension Tables.
• Experience in Informatica upgrade testing, troubleshoot and resolve issues.
• Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Extensively used Oracle to analyse data and fix errors and develop.

Environment: Informatica Power Center 8.6.1/9.1.1 , Business Objects 6.1, Oracle 9i, DB2 UDB, UNIX, Erwin 4.0, SQL Server, PL/SQL, SQL*Loader, Windows.

Confidential

ETL & Report Developer

Responsibilities:

• Experience with ETL/ETI (Extraction Transform and Loading, Extraction Transform and Import) data from production database to data warehouse database.
• The objective is to build an Integrated DW from the existing Source systems, and subsequent report development from the DW for Honda Client.
• Design/Development of reports from Data warehouse (DW) based on Business Requirements.
• Designed ETL packages with various scenarios.
• Impact analysis on existing reports\model because of change in underlying source system

Environment: Informatica Power Center 8.6.1/9.1.1, Business Objects 6.1, Oracle 9i, DB2 UDB, UNIX, Erwin 4.0, SQL Server, PL/SQL, SQL*Loader, Windows.

Confidential

ETL Developer

Responsibilities:

• Experience with ETL/ETI package migration to improve performance.
• The objective is to migrate all the applications from Red environment will be migrated to Green environment to enhance the performance and to make them reside on a dedicated server.
• Gather user requirements and prepare impacted object analysis document.
• Worked in SSIS packages and stored procedures to change the connections and code which fits the new environment.
• Migrated SSIS packages and stored procedures into new test environment and test the changes.
• Configuration changes for SSIS packages & Web Application.
• Unit testing and Functional Regression testing on remediated objects.

Environment: Informatica Power Center 8.6.1/9.1.1, Business Objects 6.1, Oracle 9i, DB2 UDB, UNIX, Erwin 4.0, SQL Server, PL/SQL, SQL*Loader, Windows.

Confidential

ETL Developer

Responsibilities:

• The Project aims at migrating the legacy system to SQL Server. The Application will load the prescribers related data from Files to the Target Tables.
• Gathering the functional requirements to build an Enterprise level data warehouse for Medical Agents.
• Analyzing the data and prepare a mapping documents according to the SSIS development standards.
• Review of the mapping documents.
• Design and develop the SSIS packages according to the requirements.
• Drafting Design documents and technical documents for the project components.
• Unit testing for the developed SSIS packages.

Environment: SSIS 2012, SQL Server 2012, SQL Server Agent.

Confidential

ETL Developer

Responsibilities:

• Requirement Analysis and preparation of Impacted object analysis document.
• Worked in DTS Packages, Stored Procedure, Views.
• Developed the Required SQL Script.
• Unit testing on remediated objects.
• Involved in preparing UTR documents.

Environment: SSIS 2012, SQL Server 2012, SQL Server Agent.