We provide IT Staff Augmentation Services!

Informatica Developer Resume

2.00/5 (Submit Your Rating)

Austin, TX

SUMMARY

  • Around 7 years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Informatica Data Quality (IDQ) 10.x/9.x, Informatica Power Center 10.x/9.x, Informatica Enterprise Data Catalog(EDC),SQL Server, Oracle etc.
  • Experience in interacting with business users to clarify requirements and translate teh requirements into technical specifications.
  • 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.
  • Experience in teh ETL Tool Informatica and has good 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, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
  • Worked in Informatica Enterprise Data catalog for finding teh assets, data domain discovery.
  • Good noledge 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.
  • Extensively worked on Relational Databases Systems like Oracle11g/10g/9i/8i, MS SQL Server.
  • 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 teh data flow and evaluating transformations
  • Strong experience in SQL, Tables, Materialized Views, Synonyms, Joins, Unions and Indexes in Oracle
  • Good noledge of 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 has 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:

  • Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
  • Good Experience in Informatica Developer/Informatica Analyst tool.
  • Strong in implementation of data profiling, creating scorecards, creating tables and documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy.
  • 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.
  • Design, Development and implementation of IDQ Mappings and Informatica BDQ Mappings for data cleansing, Data Standardization using Standardizer, Case Converter, Labeler, Parser, Expression transformations etc.
  • Worked on different IDQ Mappings to load teh data from different sources to targets based on BA SQL Scripts using different transformations like Filter, Joiner, Union, Expression, Sorter etc.
  • Developed different Mapplets/Business Rules in Informatica Data Quality (IDQ) for Data Cleansing, Data Standardization using Expression, Input, Output, Standardizer transformations and to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
  • Used IDQ’s standardized plans for addresses and names clean ups.
  • Worked on Different validation and cleansing Mapplets in informatica developer and validate these Mapplets as Rules.
  • Worked on Exceptional Handling process using Exception Transformation in Bad record exception and Duplicate Record exception strategies.
  • Worked on Human Task process for bad records or rejected records exceptions by creating Workflows.
  • 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 IDQ 10.2, Informatica Developer 10.2, Informatica Analyst 10.2, SQL ServerOracle, Informatica Scheduler.

Confidential, Detroit, MI

Informatica/IDQ/EDC Developer

Responsibilities:

  • Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
  • Developed Data Quality mappings using Informatica Data Quality to implement teh business requirements.
  • Performed teh Data profiling and analysis making use of Informatica Data Quality (IDQ).
  • Created profiles, rules, scorecards and mappings with Informatica Developer and Analyst Tool.
  • Strong in implementation of data profiling, creating scorecards, creating tables and documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy.
  • 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 teh 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, 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.
  • 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 teh 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 IDQ/BDQ 10.2.2, Informatica Developer 10.2.2, Informatica Analyst 10.2.2, Informatica EDC 10.2.2, SQL Server, Informatica Scheduler.

Confidential

Informatica/IDQ/BDQ Developer

Responsibilities:

  • Interacted with teh Business users to identify teh process metrics and various key dimensions and measures. Involved in teh complete life cycle of teh project.
  • Good proficiency in Informatica BDQ 10.2.1/10.1.1 .
  • Good proficiency in Informatica Data Quality 10.2.1/10.1.1 .
  • Good proficiency in Informatica Developer 10.2.1/10.1.1 and Informatica Analyst 10.2.1/10.1.1 .
  • Good proficiency 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 teh 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/IDQ Developer

Responsibilities:

  • Interacted with teh Business users to identify teh process metrics and various key dimensions and measures. Involved in teh complete life cycle of teh project.
  • Good proficiency in Informatica BDQ 10.2.1/10.1.1 .
  • Good proficiency in Informatica Data Quality 10.2.1/10.1.1 .
  • Good proficiency in 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 teh 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 Developer 10.2.1/10.1.1 , Toad for Oracle, SQL Server, Control - M, Informatica Scheduler, UNIX Shell Scripting, Agile/Rally.

Confidential

Informatica/IDQ 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 teh 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 Data Quality 9.6.1, Informatica Power Center 9.6.1/9.5.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 teh 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.

We'd love your feedback!