Professional Summary:

• Informatica Certified Developer with extensive industrial exposure.
• 10 plus years of IT experience.
• 9 plus years experience in developing ETL process using tools like Informatica Power Center 9.x/8.x/7.x/6.x, Data Stage 8.1/7.5 etc.
• Worked in various domains like Utilities, Pharmaceuticals, Finance and Government.
• Extensive experience in Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• Expertise in Informatica. Extensive experience in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling the Workflows and sessions.
• Deep understanding of the Data Warehousing SDLC and architecture of ETL tools.
• Created Datamaps, Registrations and Extractions in Power Exchange for DataCom using PWX Navigator.
• Experience in Real time processing using Power Exchange for DataCom.
• Worked on Informatica B2B Data Exchange.
• Experienced in developing parallel jobs using various Development/debug stages Peek stage, Head Tail Stage, Row generator stage, Column generator stage, Sample Stage and processing stages Aggregator,Filter, Sort Merge, Funnel, Remove Duplicate Stage
• Debug, test and fix the transformation logic applied in the parallel jobs
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components monitoring performance statistics.
• Strong understanding of Data Modeling Relational, dimensional, Star and Snowflake Schema , Data analysis, implementations of Data warehousing using Windows and UNIX.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL. Also loaded large files using SQL Loader.
• Scheduling jobs using Cron job and inbuilt Informatica scheduler.
• Experience in resolving issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Experience with Data Cleansing, Data Profiling and Data analysis.
• UNIX Shell Scripting, SQL and PL/SQL coding.
• Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions. Performance Tuning of Informatica Mapping and workflow.
• Dimensional Data Modeling experience using Erwin 4.5/7.3 and Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT Dimensions tables, Physical Logical data modeling, and Data Modeling Tools Visio.
• 5 years of experience as a lead, managing team, day to day activities and work assignment.
• 2 years of experience as Informatica administrator. Done user creation, Folder management, access management, deployment in various environments.
• Worked on COGNOS and OBIEE.

Technical Skills:

Professional Experience:

Confidential

Team Lead ETL Informatica

Responsibilities:

• Data Maps and Registrations creation in Power Exchange using Power Center Navigator.
• Complex data validation using PL/SQL Package.
• Created UNIX scripts for monitoring workflows at the Power Centre and Power Exchange side.
• Work assignment and coordination among the team members.
• Power Center and Power Exchange client tools up gradation to latest versions.
• Providing functional knowledge to other members of the team.
• Complex mapping, UNIX scripts and procedures development and testing.
• ST defects analysis and fixation.
• Involved in the Migration of Informatica 8.6 to Informatica 9.
• Understanding the Business requirements based on Functional specification and to design the ETL methodology in technical specifications.
• Worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Bulk loading data using wrapper scripts.
• Fine tuning Informatica code mapping and sessions and sql queries to obtain optimal performance and throughput .
• Created UNIX scripts to automate the activities like start, stop, and abort the informatica workflows by using PMCMD command in it.
• Creating deployment objects to deploy Informatica power center objects to QA,UAT and PROD .
• ST Defect analysis and assignment using IBM Clear Quest.
• Acting as secondary administrator, created users, folders and granted privileges. Involved in Informatica upgrade from Informatica 8.6 to Informatica 9.1 hotfix 4.

Environment: Informatica 8.6.1, Informatica 9.1 Hotfix 4 Repository Manager, Designer, Admin Console, Workflow Monitor, Workflow Manager , Oracle 11g, Power Exchange 9.1 Hotfix 4, Toad 9.7.2.5, AIX , IBM Rational Clear Quest, Erwin,FileZilla,Notepad , SQL Loader, COGNOS 8, B2B Data exchange.

Confidential

Senior ETL Informatica Developer

Responsibilities:

• Involved in Data Modeling.
• To study and understand business and technical requirements of the system.
• Created the design documents as per the requirement.
• Develop Mappings and workflows using Informatica 8.
• Loaded data using Power Exchange for Netezza.
• Unit Tested mappings .
• Created reusable failure and success email tasks to notify users.
• Created dependencies between workflows using event wait task and OK files
• Worked with various look-up caches.
• Worked with connected and unconnected look-up for implementing complex logic.
• Used partitioning for performance tuning.

Environment: Informatica 8.6 Repository Manager, Designer, Admin Console, Workflow Monitor, Workflow Manager ,Netezza,OBIEE 11g, ERWIN, UNIX, MS Visio, SQL Developer,PL/SQL,Power Exchange for Netezza

Confidential

Module Lead ETL Informatica

Responsibilities:

• Interacted with Business Analyst and client to get functional knowledge.
• To study and understand business and technical requirements of the system.
• Created high level design documents as per the requirement.
• To provide functional knowledge of subject area to junior members of the team.
• Developed complex mappings, scripts and procedures.
• Develeoped IDQ plans for outbound files.
• UAT defect analysis and resolution.
• Fine tuning the Informatica code and sql queries to obtain optimal performance and throughput
• Created deployment objects to deploy Informatica power center objects to QA,UAT and PROD
• Created change request tickets to deploy objects to QA,UAT and PROD
• Used various tasks like Event wait , Email and Command task.
• Loaded some third party files using SQL Loader.

Environment: Informatica 8.6.1 Repository Manager, Designer, Admin Console, Workflow Monitor, Workflow Manager , Oracle 9i, Toad 9.7.2.5, AIX , IBM Rational Clear Quest, Erwin, FileZilla, Maestro ,Notepad , Informatica Data Quality

Confidential

Senior ETL Informatica Developer

Responsibilities:

• Created high level design documents as per the requirement.
• To provide functional knowledge of subject area to junior members of the team.
• Developed complex mappings, scripts and procedures.
• UAT defect analysis and resolution.
• Fine tuning the Informatica code and sql queries to obtain optimal performance and throughput
• Worked closely with DBA team to tune the performance of the Database.
• Analyzed IMS data for Sales Marketing analysis and reporting.
• Wrote stored procedures and functions .
• Performed integration testing for various mappings. Tested the data and data integrity among various sources and targets.
• Worked with various look-up caches.
• Worked with connected and unconnected look-up for implementing complex logic.
• Used partitioning for performance tuning.
• Identified the bottle necks and tuned the mappings and sessions to improve performance.
• Created deployment objects to deploy Informatica power center objects to QA,UAT and PROD
• Created change request tickets to deploy objects to QA,UAT and PROD

Environment: Informatica 8.6 Repository Manager, Designer, Admin Console, Workflow Monitor, Workflow Manager , Oracle 10g, AIX, MS Visio, SQL Developer, Erwin 7.3.4, File Zilla, Maestro

Confidential

ETL Informatica Developer

Responsibilities:

• To study and understand business and technical requirements of the system.
• Created high and low level design documents as per the requirement.
• To provide functional knowledge of subject area to junior members of the team.
• Developed complex jobs, scripts and procedures.
• Used various stages development/debug stages Peek stage, Head Tail Stage, Row generator stage, Column generator stage, Sample Stage and processing stages Aggregator,Filter, Sort Merge, Funnel, Remove Duplicate Stage .
• Identified the bottle necks and tuned the jobs to improve performance.
• UAT defect analysis and resolution.
• Created change request tickets to deploy objects to QA,UAT and PROD

Environment: Ascential DataStage, Oracle 9i, Toad 9.7.2.5, AIX, IBM Rational Clear Quest, File Zilla, Maestro

Confidential

ETL Informatica Developer

Responsibilities:

• Interacted with Business Analyst and client to get functional knowledge.
• To study and understand business and technical requirements of the system.
• Created high and low level design documents as per the requirement.
• To provide functional knowledge of subject area to junior members of the team.
• Developed complex mappings, scripts and procedures.
• Worked with various look-up caches.
• Worked with connected and unconnected look-up for implementing complex logic.
• Used partitioning for performance tuning.
• Identified the bottle necks and tuned the mappings and sessions to improve performance.
• UAT defect analysis and resolution.
• Fine tuning the Informatica code and sql queries to obtain optimal performance and throughput
• Created deployment objects to deploy Informatica power center objects to QA,UAT and PROD
• Created change request tickets to deploy objects to QA,UAT and PROD

Environment: Informatica 8.6.1 Repository Manager, Designer, Admin Console, Workflow Monitor, Workflow Manager , Oracle 9i, Toad 9.7.2.5, AIX, IBM Rational Clear Quest, Erwin, File Zilla, Maestro