SUMMARY

• Around 7 Plus years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Informatica Power Center 10.x/9.x, Informatica Data Quality etc.
• Expertise in the ETL Tool Informatica anGCPd have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor
• Extensively worked with several mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
• Extensively worked on Relational Databases Systems like Oracle 12c/11g/10g/9i/8i, MS SQL Server, DB2 and Source files like flat files, XML files and COBOL files.
• Experience in interacting with business users to clarify requirements and translate the requirements into technical specifications.
• Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions
• Extensive experience in debugging mappings, identifying bottlenecks/bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modeling.
• Experience in implementing business requirements, error handling, job control & job auditing using Informatica Power Center tool.
• Expertise in Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ.
• Strong in implementation of data profiling, score cards, creating tables and documenting Data Quality metrics/dimensions like Accuracy, creating completeness, duplication, validity, consistency.
• Worked in Informatica Enterprise Data catalog for finding the assets, data domain discovery.
• Good knowledge in creating Resources in EDC Administrator to extract metadata from sources like Hive, SQL Server etc.
• Good Experience in Data Domain Curation process for different resources using Bulk Export/Bulk Import method in EDC UI.
• Good Experience in creating Business Terms in Informatica Analyst.
• Good Experience in associating Business Terms for columns in EDC UI.
• Strong experience in SQL, Tables, Materialized Views, Synonyms, Joins, Unions and Indexes in Oracle
• Good Experience in UNIX, Shell scripting, experience in command line utilities like Infacmd to execute workflows in non-windows environments
• Experienced in scheduling Informatica jobs using Informatica Scheduler.
• Good Experience in Scheduling Jobs using Control M tool.
• Analyzed current system and programs and prepared gap analysis documents
• With both On-site and Off-shore experience have developed skills in system analysis, troubleshooting, debugging, deployment, Team management, prioritizing tasks and customer handling.

TECHNICAL SKILLS

Operating System: UNIX, Windows

Programming and Scripting: SQL, Shell ScriptingSpecialist Applications & Software Informatica Power Center 10.2.0/10.1.1/9.6/9.1 , Informatica Data Quality (IDQ) 10.2/10.1/9.6 , Informatica Enterprise Data Catalog 10.2/10.1 etc.

Databases tools: MS SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle)

Scheduling tools: Informatica Scheduler, Control-M.

Software Development Methodology: Agile, Waterfall.

Domain Expertise: Finance/Health Care/Retail

RDBMS: Oracle11g/10g/9i, MS SQL Server 2005/2008, MS Access 7.0/2000.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Informatica Developer

Responsibilities:

• Good Experience in Informatica Power Center 10.4, Informatica Developer 10.4, Informatica Analyst 10.4.
• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Developed ETL programs using Informatica to implement the business requirements.
• TEMPEffectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions) Type 1 and Type 2.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Used connected and Unconnected Lookup transformations and Lookup Caches in looking the data from relational and Flat Files. Used Update Strategy transformation extensively with DD INSERT, DD UPDATE, DD REJECT, and DD DELETE.
• Design a structure and schedule a job to load the data into table and virtual tables to test and analyze the structure and the data loaded into the table.
• Develop mappings, workflows and monitor the results using Informatica Power Center tool to meet the requirements.
• Used relational SQL wherever possible to minimize the data transfer over the network.
• Involved in maintenance and enhancements activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Imported the IDQ address standardized mappings into Informatica Designer as a Mapplets.
• Modify Business logic code to the changed requirement of the client.
• Perform test plan preparation, unit and system testing.
• Involved in creating UNIX shell scripts for Data stage job and Informatica workflow execution
• Strong in implementation of data profiling, creating scorecards, creating tables and documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy.
• Design, Development and implementation of Informatica IDQ Mappings for data cleansing using Standardizer, Case Converter, Labeler, Parser, Expression, Filter transformations etc.

Environment: Informatica Power Center 10.4, Informatica Developer 10.4, Informatica Analyst 10.4, SQL Server, Oracle, UNIX Shell Scripting, Informatica Scheduler.

Confidential, Detroit, MI.

Informatica Developer

Responsibilities:

• Good Experience in Informatica Power Center 10.2, Informatica Developer 10.2, Informatica Analyst 10.2.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Extensively using informatica ETL to load data using power center from source systems like flat files into staging tables and load the data into the target database oracle.
• Involving in business analysis and technical design sessions with business and technical staff to develop requirement document and ETL specifications.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Responsible for creating workflows. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager
• Worked with Informatica Data Quality 10.1.1/10.2.1 (Informatica Developer, Informatica BDQ and Analyst Tool) to create Column profiles, DQ Rules, Mapplets, Scorecards.
• Performed the Data profiling and analysis making use of Informatica Data Quality (IDQ).
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
• Using IDQ, performing data quality operations such as data profiling, developing scorecards, column profiling, join analysis, creating tables etc.
• Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules and also worked on creating DQ Rules in Informatica Analyst tool based on Data Steward Inputs.
• Good Experience in Data Domain Curation process for different resources using Bulk Export/Bulk Import method in EDC UI.
• Good Experience in creating Business Terms in Informatica Analyst.
• Good Experience in associating Business Terms for columns in EDC UI.
• Interacted with Data Stewards for the issues of Data Domain curation process and Business terms association process.
• Good Knowledge in creating Resources for different databases in EDC Administrator.
• Good Knowledge in creating Data Domains in EDC Administrator.
• Worked on Migration of Informatica Mappings, Data Objects, Profiles, Mapplets and Scorecards from one environment to other environment using Export and Import options in Informatica Developer Tool.

Environment: Informatica Power Center 10.2.2, Informatica Developer 10.2.2, Informatica Analyst 10.2.2, Informatica EDC 10.2.2, SQL Server, Informatica Scheduler.

Confidential, Richmond, VA.

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Good Experience in Informatica Power Center 10.2.1/10.1.1 .
• Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules and also worked on creating DQ Rules in Informatica Analyst tool based on Data Steward Inputs.
• Created profiles, rules, scorecards and mappings with Informatica Developer and Analyst Tool.
• Worked on Logical Data objects using expression, joiner etc transformations in informatica Developer and informatica BDQ Tool.
• Strong in implementation of data profiling, creating score cards, Creating tables and documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy, Consistency.
• Worked with Informatica Data Quality 10.1.1/10.2.1 (Informatica Developer, Informatica BDQ and Analyst Tool) to create Column profiles, DQ Rules, Mapplets, Scorecards.
• Performed the Data profiling and analysis making use of Informatica Data Quality (IDQ).
• Design, Development and implementation of Informatica Developer and Informatica BDQ Mappings for data cleansing using Standardizer, Case Converter, Labeler, Association, Parser, Expression, Filter transformations etc.
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
• Using IDQ, performing data quality operations such as data profiling, developing scorecards, column profiling, join analysis, creating tables etc.
• Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules and also worked on creating DQ Rules in Informatica Analyst tool based on Data Steward Inputs.
• Worked on Migration of Data Objects, Profiles, Mapplets and Scorecards from one environment to other environment using Export and Import options in Informatica Developer Tool.
• Wrote and ran different type of SQL queries on SQL Server and Oracle SQL Developer.

Environment: Informatica BDQ 10.2.1/10.1.1 , Informatica Developer 10.2.1/10.1.1 , Informatica Analyst 10.2.1/10.1.1 , Oracle, SQL Server, Control - M, Informatica Scheduler, Windows Power Shell, UNIX Shell Scripting, Agile/Jira.

Confidential

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Good proficiency in Informatica Power Center 10.2.1/10.1.1 , Informatica Developer 10.2.1/10.1.1 and Informatica Analyst 10.2.1/10.1.1 .
• Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules and also worked on creating DQ Rules in Informatica Analyst tool based on Data Steward Inputs.
• Created profiles, rules, scorecards and mappings with Informatica Developer and Analyst Tool.
• Worked on Logical Data objects using expression, joiner etc transformations in informatica Developer and informatica BDQ Tool.
• Strong in implementation of data profiling, creating score cards, Creating tables and documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy, Consistency.
• Worked with Informatica Data Quality 10.1.1/10.2.1 (Informatica Developer, Informatica BDQ and Analyst Tool) to create Column profiles, DQ Rules, Mapplets, Scorecards.
• Performed the Data profiling and analysis making use of Informatica Data Quality (IDQ).
• Design, Development and implementation of Informatica Developer and Informatica BDQ Mappings for data cleansing using Standardizer, Case Converter, Labeler, Association, Parser, Expression, Filter transformations etc.
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
• Using IDQ, performing data quality operations such as data profiling, developing scorecards, column profiling, join analysis, creating tables etc.
• Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules and also worked on creating DQ Rules in Informatica Analyst tool based on Data Steward Inputs.
• Worked on Migration of Data Objects, Profiles, Mapplets and Scorecards from one environment to other environment using Export and Import options in Informatica Developer Tool.
• Wrote and ran different type of SQL queries on Hive, SQL Server and Oracle SQL Developer.

Environment: Informatica Power Center 10.2.1/10.1.1 , Informatica Developer 10.2.1/10.1.1 , Toad for Oracle, SQL Server, Control - M, Informatica Scheduler, UNIX Shell Scripting, Agile/Rally.

Confidential, Tampa, FL

Informatica Developer

Responsibilities:

• Work closely with team of business users to gather business requirement and translate into technical specification.
• Created profile, rules and mappings with Informatica Developer and Analyst Tool.
• Strong in implementation of data profiling, creating score cards, Creating tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ 9.6.1.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Design, Development and implementation of Informatica Developer and Informatica BDQ Mappings for data cleansing using Standardizer, Case Converter, Labeler, Association, Parser, Expression, Filter transformations etc.
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
• Using IDQ, performing data quality operations such as data profiling, developing scorecards, column profiling, join analysis, creating tables etc.
• Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules and also worked on creating DQ Rules in Informatica Analyst tool based on Data Steward Inputs.
• Using IDQ to perform data profiling, data cleansing, creating tables, scorecards etc.
• Wrote and ran different type of SQL queries, including create/insert/update on given databases

Environment: Informatica Power Center 9.6.1/9.5.1 , Informatica Data Quality 9.6.1, SQL Developer, Toad for Oracle, UNIX Shell Scripting.

Confidential

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
• Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.
• Collaborating with Business Analysts by providing analysis, consultation, coding, testing and documentation in accordance with the specification and target completion dates.
• Developed mappings in Power center for Job Monitoring and Data Validation.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, SQL, Update strategy and Sequence generator.

Environment: Informatica Power Center 9.1.0, JIRA, SQL Developer, MS Access.