We provide IT Staff Augmentation Services!

Etl Informatica/ Idq Developer Resume

Jacksonville, FloridA

SUMMARY

  • I have over all 10 years of IT experience with 3 years of testing experience and 7 years of IDQ experience.
  • 7+ years of IT experience in Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems
  • Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment
  • Good proficiency in Informatica Data Quality 10.2.1/10.1.1 /9.6.1 and Informatica Power Center 10.2.1/10.1.1 /9.6.1
  • Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools.
  • Experience in complete Software Development Life Cycle (SDLC) (Requirement Analysis, Design, and Development & Testing).
  • Experience in dealing with the different source systems analysis and data extraction from various sources like Flat files, Oracle, DB2, Teradata files and extensively used ETL to load data using Power Center and Data Analysis using IDQ tool
  • Experience in using SQL loader for conventional path loading and direct path loading into Oracle tables
  • Strong experience working in data migration and conversion projects
  • Establishes, enhances, implements, enforces, and maintains ETL,Data Quality and data integration best practices
  • Experience in Data Extraction, creating Column Profiling, Rule Profiling, Mid - stream Profiling, Join analysis profiling, Data Domain, Domain discovery, Scorecards, Data lineage, Data Cleansing, Data Standardization, Match & Merge process and Data Deduplication using Informatica Data Quality 10.2 HF2.
  • Good experience on rule specification, Mapping specifications, Virtual data objects(VDO), Custom Data Objects(CDO),Logical Data Objects (LDO),Physical Data Objects(PDO), mapplets, rules and reference data management.
  • Experience with deploying the mapplets as service and using them in downstream process.
  • Experienced in mapping techniques for Type 1, Type 2, Type 3 Slowly Changing Dimensions, fact loads On Incremental basis using Control tables/mapping level variables/parameter files
  • Extensively worked with complex mappings using various transformations like Expression, Lookup, Filter, Router, Union, Aggregator, Joiner, Update Strategy, Sequence generator, Java Transformation, Labeller, Match, Merge, Decision, Exception, Key Generator, Standardizer, Case Converter, Consolidation, Parser, Address validator and Reusable Transformations, User Defined Functions etc.
  • Expertise in building the mapplets for data Standardization, Address Validation, De-duplication Integrating the IDQ mapplets with Power Center.
  • Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
  • Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
  • Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and pmcmd/infacmd command utilities
  • Proficient in creating Test Strategy, Test Design and Test Plans and Automated Testing.
  • Collecting and understanding the Business Requirements for the project and translating these into Functional Testing and detailed Test Cases for Manual & Automated Testing.
  • Good Experience in working in an AGILE environment and participated in Scrum & Sprint meetings.

TECHNICAL SKILLS

DQ Tools: Informatica Data Quality 10.x/9.x

ETL Tools: Informatica Power Center 10.0/9.x/8.x

Databases: Oracle 11g/10g/9i, SQL Server 2012, DB2

Database Tools: TOAD, SQL*PLUS, SQL Developer

Programming Tools: C, C++, SQL, PL/SQL

Operating Systems: Windows Server/AIX/UNIX/LINUX

Testing tools: Rally, HP ALM, Clear Quest, JIRA, Bugzilla

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, Florida

ETL Informatica/ IDQ Developer

Responsibilities:

  • Worked with Business Analysts (BA) to analyze the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue.
  • Involved in doing the data profiling and creation of scorecards to analyze the data with respective different measures and Automating the profile and scorecard run with UNIX scripting
  • Created mappings, workflows, mapping specifications, rule specification,mapplets, rules, reference data, LDO, CDO, VDO and applications in IDQ.
  • Good experience on IDQ code deployment
  • Created the Bad/De-Dup record exception process and configured the Human Task for automating the exception process.
  • Working with different Data Governance teams for IDQ code promotion to across all the environments
  • Experience on Data Governance principles and Meta data management
  • Creating the UNIX scripts for Profile and scorecard automation process.
  • Good experience on creating the different types of DB Connection on IDQ and BDM domains
  • Working on Performance tuning of LDO’s, profiles and scorecards
  • Creating the change requests as per change control process to promote the Data Quality objects to higher environments
  • Worked on Scheduling Jobs and monitoring them through CA scheduler tool (Autosys).
  • Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.

Environment: Informatica Developer 10.2.1/10.1.1 , Informatica Analyst Tool 10.2.1/10.1.1 , Agile, TOAD, Putty, PL/SQL, UNIX Shell Scripting, Flat Files

Confidential, NJ

Informatica/ IDQ Developer

Responsibilities:

  • Worked with Business Analysts (BA) to analyze the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue.
  • Created the Address Validation and Data Processor mapplets and Integrated with power Center.
  • Involved in doing the data profiling and creation of scorecards to analyze the data with respective different measures and Automating the profile and scorecard run with UNIX scripting
  • Created mappings, workflows, mapping specifications, rule specification, mapplets, rules, reference data, LDO, CDO and applications in IDQ.
  • Good experience on IDQ code deployment and Code integration with Informatica power center.
  • Good experience on privileges, roles, groups, user in IDQ Admin console
  • Good experience on Connection creations in IDQ Admin console
  • Created the Bad/De-Dup record exception process and configured the Human Task for automating the exception process.
  • Created Informatica Power Center mappings,sessions, workflows and automated the runs

Environment: Informatica Data Quality 9.6.1, Informatica Power Center 9.6.1/9.5.1 SQL, Oracle 11g/10g, Autosys, QL Server, SQL* Loader, SQL developer, PLSQL developer, TOAD, Putty, PL/SQL, UNIX Shell Scripting, Flat Files, Control-M

Confidential

INFORMATICA/IDQ DEVELOPER& Test engineer

Responsibilities:

  • Documented user requirements, translate requirements into system solutions and developed an implementation plan and schedule.
  • Extracted data from relational databases DB2, Oracle and Flat Files
  • Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into DataMart, Enterprise Data warehouse (EDW)
  • Developed data Mappings, Transformations between source systems and warehouse
  • Performed Type1 and Type2 mappings
  • Worked on OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing PL/SQL.
  • Well Versed in building test strategy on IDQ Mappings, Profiles.
  • Experience in profiling the data and performed Proof of Concept for Informatica Data Quality (IDQ)
  • Created Profiles using IDQ rules and filters.
  • Applying cleansing rules using IDQ.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
  • Performing Unit testing and tuned the mappings for the better performance
  • Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Prepare Estimates for the Requirements
  • Involved in testing phases including Integration Testing, Regression Testing and User Acceptance testing.
  • Prepared and executed Test Cases.
  • Involved in Test Case Reviews and updating.
  • Prepare & Review the Test Plan, Strategy and Exit Report Documents
  • Manage the Functional, Performance and Automation Teams and utilize the resources as per requirement
  • Ensure preparation of Test data required for Functional Testing
  • Used SQL to validate backend database changes, deletes and update

Environment: IDQ Informatica Developer Tool 9.6.1, IDQ Informatica Analyst Tool 9.6.1, Informatica Power Center 9.6, Oracle 11g, Windows Server 2008

Confidential

Junior Research tester

Responsibilities:

  • Typed “A” class documents using “I leap” software.
  • Scanned the above documents and tested them in OCR system.
  • Creating the library for Telugu characters at Unicode level.
  • Partially worked on annotated data.
  • Involved in verifying the code as per the unit testing level requirements specified in design documents
  • Good Experience in resolving issues encountered during analysis by interacting with various onsite leads

Hire Now