SUMMARY:

• 8+ years of IT industry experience in Data Warehousing Business Intelligence and System Integration project using Informatica Power Center (ETL) 7x, 8x and 9x, DataStage and OWB.
• Proficient in business analysis, technical design, implementation, testing and support in data warehousing, business intelligence and data integration projects.
• 16 Months of experience in leading, mentoring and onsite co - ordination.
• Outstanding leadership abilities - able to coordinate and direct all phases of project based efforts while managing, motivating and leading project teams and excellent on onsite offshore model coordination.
• Data modeling experience in using Power Designer for Dimensional Data modeling and Star/Snowflake Schema modeling.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using informatica power exchange.
• Experienced with Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling.
• Data Quality Analysis to determine cleansing requirements.
• Strong Experience in Informatica - Design, Work Flow Manager, Repository Manager, Monitor and other tools used in the Transformation and Mapping, Migration, Transaction and Batch processing.
• Experience in Informatica power center installation and admin activities.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in Agile development environment and participated in Scrum meetings.
• Prepare project estimates, delegation of tasks and duties to team members.
• Excellent time management skills with reputation of meeting deadlines.
• Knowledge of coding ETL Tasks in UNIX Shell scripts.
• Experience in using Autosys and Informatica Scheduler for scheduling Workflow sessions.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, DB2, SQL Server, Netezza and Worked on integrating data from flat files like fixed width and delimited.
• Extensively worked with Oracle, PL/SQL Stored Procedures, and Functions and involved in Query Optimization.
• Extensively worked on Unix Scripting
• Defined the program specifications for the data migration/conversion programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.

SKILLS:

ETL Tools: Informatica 7.x/8.x/9.x, DataStage, OWB, Informatica Data Quality

Reporting Tools: Cognos, OBIEE

Methodologies: Star Schema, Snow Flake Schema

RDBMS: Oracle 9i/8i/10g/11g, Oracle Exadata, SQL server 2012, Netezza 4.0, MySQL

Languages: SQL, PL/SQL, UNIX shell Scripting, XML, PHPJavaScript

Operating System: Windows 9X/2k, Windows NT

Data Modeling: Power Designer

Scheduler Tools: Appworx

Change Management: HP Quality Center

Database tools: Toad, SQL Developer

PROFESSIONAL EXPERIENCE:

Senior ETL Developer/ETL lead/Analyst/Onsite Coordinator

Confidential, Atlanta, GA

Responsibilities:

• Successfully handling multiple projects. Single Point Of Contact (SPOC) for project delivery at onsite
• Worked with end users to understand the business requirements and business rules.
• Analyzing the functional requirements and developing design documents like HLD, LLD, S2T mappings.
• Identify opportunities for further enhancements and refinements to the ETL standards and processes.
• Successfully leading a Team of 5-15 people with following responsibilities
• Task Assignments within team with defined priority by client.
• Responsible for controlling project requirements, scope, and change management issues.
• Ability to define and implement approaches to load and extract data from multiple data sources.
• Involved in creating Logical & Physical models and used Power Designer for data modeling.
• Involved in Data model reviews and validated the tables, columns and data types to meet the requirements.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool.
• Code reviews of Informatica Mapplets, Mappings, and Workflows Test with negative data, Unit testing
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database
• Extract data from Flat files and Oracle Database using Informatica.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate Daily, Monthly and yearly Loading of Data.
• Automated the jobs through Scheduling using built in Informatica Scheduler.
• Extensively used Source qualifier, Aggregator, Filter, Joiner, Expression, lookup, Router, Sequence Generator, Update Strategy, Union and SQL transformations to create mappings
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Extensively worked on tuning and improving the load time as well query processing time.
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, modifying session properties and partitioning the mapping.
• Used Error Handling Mapplet to capture error data into PMERR tables for handling nulls, analysis and error remediation Process.
• Documented the workflow dependencies and ordering for Autosys job scheduling process.
• Interacted with the SME to implement requirements with out affecting performance of the process.
• Coordinate the resolution of any issues with delivered customizations with other teams and onsite/offshore team.
• Reporting and Data analysis using OBIEE reporting tool.
• Reviews and ensures the work products are delivered within agreed schedule/quality
• Worked with the Testers in writing test cases and validated test Cases prepared by them.
• Take personal responsibility while delivering the complex data objects.
• Collect weekly reports on the developments of the project.
• Personal responsibility towards team members.
• Preparing high level support manual for the Production support and transitioning the project knowledge to Support team.

Senior ETL developer /Onsite Coordinator

Confidential

Technologies: Informatica Power Center 9.x/8.x, Informatica Data Profiler/Explorer, Oracle 9i/10g/11g, Power Designer, SQL, PL/SQL, TOAD, Unix scripting, Curl, XPATH, JSON.

Responsibilities:

• Analysis on data quality issues using the tie-out queries and fixing the same in OWB (Oracle Warehouse builder)
• Developed script (perl script) for populating daily Cognos temp table creation statistics.
• Involved in Report query data validation.
• Developing mappings and jobs in IBM InfoSphere Datastage and IBM InfoSphere CDC.
• Preparing Design document for the datastage mapping logic.
• Responsible for resolving any failure to daily job loads.
• Involved in Test case preparation and UTC for newly developed mappings both in OWB and Datastage.

Confidential

ETL Developer

Responsibilities:

• Complex ETL mappings development using Informatica Data Quality/Powercenter.
• Master data management using Informatica MDM tool.
• Analysis of data using complex SQL query.

Technologies: Informatica Powercenter/Data Quality, Informatica Master Data Management, Oracle, UNIX scripting.

Confidential

ETL Developer

Responsibilities:

• ETL (Informatica) integration with OBIEE package.
• Informatica installation, configuration and admin activities on Windows OS.
• Integrating Informatica jobs with DAC (OBIEE Execution and monitoring tool).

Technologies: Informatica Powercenter, OBIEE

Confidential

ETL Developer

Responsibilities:

• Develop Mapping (OWB and Informatica) and Interfacing UNIX shell scripts
• Develop mappings for Historical Data migration using OWB (from Informix db to Oracle db)
• Preparing and conducting Test cases for Informatica and OWB mappings developed.
• Coordinating work efforts with other support groups to find the correct root cause of problems with interfacing applications.
• Requirement analysis, Enhancements of existing mapping codes and Daily Monitoring Jobs Involved in Informatica Administration Activities like
• User Management, Folder Management, forced kill Jobs etc.

Technologies: Informatica Powercenter

Confidential

ETL Developer

Responsibilities:

• Fixing production data's in errors.
• Develop mappings and enhancing existing mappings.
• Develop UNIX shell script for Informatica interface.
• Debugging Report in Cognos 7 impromptu.
• Monitoring Daily Informatica jobs and takes necessary steps in case of load failure

Technologies: Informatica Powercenter, Oracle Database