SUMMARY:

• 10 years of functional and technical IT experience in analysis, design, development, testing and implémentation of ETL / Data Warehouse Technologies using Informatica 8.x to 10.x.
• Hands on experience on all phases of software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, implementation and reviews.
• Extensive ETL experience using Informatica PowerCenter client tools (Designer, Workflow Manager, Workflow Monitor and Server Manager) and Informatica.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and Sessions using Informatica Power Center.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router and reusable transformation using Informatica PowerCenter Designer.
• Expertise in debugging and performance tuning the performance of Mappings and Sessions in Informatica and determining the performance bottlenecks.
• Experience in different software development methodologies like Waterfall Model and Agile Software Development process.
• Sound knowledge of Entity - Relationship (ER) Data modelling.
• Experience in interaction between cross functional teams to share the common methodologies, Technical designs/discussions and Project dependencies
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions, Cursors, Indexes and Triggers and involved in Query Optimization
• Experience in Telecom, Banking and Financial domains.
• Expertise in implementing complex business rules involving financial calculations.
• Expertise in Analysis, Design and Implementation of Oracle Golden Gate for Oracle DB and data replication across regional data centers.
• Experience in UNIX Shell scripts for validating and scheduling Informatica jobs.
• Extensively worked on requirements gathering, design, Coding, Reviews, Unit testing, Test strategies and implementation.
• Knowledge of Informatica MDM.
• Demonstrated ability to work and communicate effectively with both business and technical audiences.
• Experience working as an Onsite Tech Lead coordinating with offshore teams
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem.
• Willingness to learn and work on new technologies.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 8.1/8.6.1/9.1.0/9.6.1/10.1. Talend, Syncsort.

Languages: C++, Java, Java script, SQL, PL/SQL, Unix Shell Scripting

Middleware: Oracle Golden Gate 10.1

Databases: Oracle 11g/10g/8i/9i, SQL Server 2000/2005/2008, DB2MS Access 7.0/97/2000, Teradata.

Tools: TOAD for Oracle, SQL Developer, SQL* Loader

Data Modelling: Dimensional Data Modelling, Star Schema and Snowflake Schema, Erwin.

Scheduling Tools: Informatica Scheduler, Autosys, Tivoli, Crontab

Project Management: MS Projects, MS Office and Visio

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. Informatica Developer

Responsibility:-

• MDM Hub Configuration Development: Creating BO, Stage and Landing tables, Setting up relationship, Match Path configuration as per data model, Creating load mapping, cleanse function, HM setup-creating entity types, relationship base objects, relationship types, profiles, put and display Queries.
• Hands on experience on developing IDQ Profiles.
• Performed data analysis and validation of the data received from upstream systems.
• Defined Trust and validation rules before loading the data into the base tables
• Create MDM mappings using IHA best practices to capture the errors and have a clean load using Informatica power center.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Preparation of technical specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining the standards.
• Perform impact analysis, identifying gas and code changes to meet new and changing business requirements.
• Created informatica mappings to extract data from Trizetto Facets 4.51 and 4.3 claims database. Analyzed the Trizetto Facets 4.51 data model and assist the Data architecture team to build claims Canonical data model in the ODS.
• Worked with various informatica transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update strategy, Stored procedure, Router and Normalizer etc.
• Worked with connected and unconnected stored procedure for pre and post load sessions.
• Involved in production support and resolving the production issues promptly by attending the high priority issues immediately providing best customer support.

Environnent:- MDM 9.5.0, Informatica MDM Data Director 9.1.0, Informatica Data Quality (IDQ) 9.5.0,Informatica Power Center 9.1.0, Informatica Power Exchange, Windows XP/2003, UNIX, Oracle 11g/10g, Trizetto Facets 4.51/4.31, MS SQL server 2005/2012, SQL, PL/SQL, WinScp, HummingBird, IBM Tivoli Work Load Scheduler, SSRS.

Confidential, Atlanta, GA

ETL Designer and Developer

Responsibility:-

• Understanding Business requirements and preparing HLD and detailed design documnent business requirement.
• Develop Mappings, Sessions, Workflow and scheduled the Workflow to run Confidential a specified frequency.
• Impact analysis of functional changes required in existing systems.
• Performance tuning for proposed solutions.
• Developing and designing new & modifying existing INFA and Unix components.
• Developed Unix shell scripts for file validation, SQL programming and to automate the validation and execution of Informatica jobs.
• Develop database scripts such as SQL queries, PL/SQL Packages, Stored Procedures, Triggers, Functions, Cursors and Indexes.
• Monitoring, Enhancement & Quality addition to Production processes.
• QC deployment and testing.
• Develop troubleshooting guides for operation support team and provide training to operation support team.
• Developed Initial data load scripts to load data across Databases.
• Coordinate with Infrastructure team, system administrator to deploy application in production environment .
• Root cause analysis of the failed jobs.
• Develop golgen gate pocesses to facilitate near realtime data replication.
• Design and implementation of Oracle GoldenGate active-active, Bi-Directional Replication between Oracle Databases
• Preparation of Unit Test Plan and Unit Test cases for the business scenarios
• Performing unit testing and Integration testing scenarios.
• Performing code reviews according to standards.
• Tracking the defects and fixing them.
• Deployment support handle using check list in different environment.
• Release coordination & Implementation activities.
• Provided on call production support on rotation basis within the team .
• Handling client calls and discussing the daily issues and concerns.

Environnent: Informatica 9.5.1/9.6.1, Oracle 11g, Golden Gate 10, 11.1, Unix, SQL, PL/SQL

Confidential

ETL Developer.

Responsibilities:

• Developed Informatica mappings, sessions and workflows to load the data from the source to staging levels and from staging tables to the respective Dimensions and Fact tables.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Migration of Informatica code to QA and Production Environments.
• Scheduling the jobs in production.
• Monitor the production jobs through IPC Workflow Monitor,Tivoli,Oracle and UNIX.
• Fixing the load failures and restart the load to meet SLA (Service Level Agreement).
• In case of Job Failure Fix the Problem and make the job run successfully.
• Capture failures and process messages.
• Document all the failures and leverage on them when the similar situation occurs
• Validate the production run after successful job execution.
• Root cause analysis of the failed jobs.
• Co-ordinate with all the application groups on any issues.
• Update the run book as and when required.
• Escalating data issues to clients encountered during the load

Environnent: Informatica 8.6.1, Oracle 11g, SQL, Unix, PL/SQL

Confidential

Executive Professional Services/Developer

Responsibilities:-

• Develop Server Side scripts to handle transactions within Netsuite system
• Develop user event scripts to execute when certain event is fired.
• Involved in writing Procedures, functions & packages
• Responsible for reconciliation of the sales through Pensio and Collector Payment Gateways for credit card payments.
• Carrying out builds/deployment on test and production servers.
• Active participation in developing and deciding an approach for implementing a new requirement.

Environment: PLSQL, SQL, JavaScript, xml, Netsuite API, Payment Gateways API

Confidential .

Developer and Support Executive

Responsibilities:

• Developed Informatica workflows to load the data from the source to staging levels and from staging tables to the respective Dimensions and Fact tables.
• Scheduling the jobs in production.
• Monitor the production jobs through IPC Workflow Monitor, Tivoli, Oracle and UNIX.
• Fixing the load failures and restart the load to meet SLA (Service Level Agreement).
• In case of Job Failure Fix the Problem and make the job run successfully.
• Capture failures and process messages.
• Document all the failures and leverage on them when the similar situation occurs
• Validate the production run after successful job execution.
• Root cause analysis of the failed jobs.
• Co-ordinate with all the application groups on any issues.
• Update the run book as and when required.
• Escalating data issues to clients encountered during the load

Environment: - Informatica 8.1, Oracle 11g, SQL, Unix .