Informatica Developer
Resume:
PROFESSIONAL SUMMARY
About *+ years of ETL experience in Analysis, Design, Development and Implementation of Data warehouse systems in Informatica 9.X/8.X, Oracle, DB2 and Tidal.
Extensive experience with Data Warehouse, BI methodologies and strong understanding of Relational, Multi-Dimensional concepts and OLAP.
Experience in Data Warehouse development working with Data conversion, Data migration and (ETL) Extraction/Transformation/Loading using Informatica Power Center with Oracle.
Expertise in developing ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle and DB2 into a common target area such as Staging, Data Warehouse and Data Marts.
Strong knowledge in waterfall and Agile project implementation methodologies.
Expertise in implementing complex business rules using different Transformations and Mapplets
Expertise knowledge in improving Performance and Troubleshooting of the Informatica mapping and sessions.
Has domain expertise in implementation of large-scale applications with the Data warehousing.
Well Versed with different SQL Development Tools like TOAD & SQL Developer
Have good knowledge in UNIX Shell Scripting, SQL and PL/SQL.
Flexible and versatile to adapt to new environment and working on new projects.
Committed to continuous improvement and excellent communications. Self-disciplined, focused, solid teamwork and good team player.
Good experience in technical documentation.
Excellent analytical, problem solving skills. Ease of working within a team and independently. Good communication and presentation skills.
TECHNICAL EXPERTISE
Databases: Oracle 10g
ETL tools: Informatica Power Center 9.x/8.x
BI Tools: Business Objects XIR2
Database Access Tools: TOAD, SQL*Plus, SQL developer
Operating Systems: Windows XP/2000/NT, MS DOS, UNIX
Scheduling Tools: Tidal
PROFESSIONAL EXPERIENCE
Independent health, Buffalo, NY Jul 2014 – June 2015
ETL developer consultant
The purpose of this project is to extract member data from health rules and send to Intelliscan. This involves creating a process to extract Health Rules Members that are attached to a group that is enrolled in an EMPOWER benefit plan that were just enrolled or enrolled and member data has changed. Worked on another requirement for ‘Use UOI Eff & Term Dates to Determine Member Benefit’ and few other enhancements during this time period.
Responsibilities:
Imported source and target definitions using Source Analyzer and Warehouse Designer components of Informatica for various source/target types: flat files, DB2 and Oracle
Created ETL mappings using various Informatica transformations: source qualifier, data quality, Dynamic lookups, expression, filter, router, sorter, aggregator, SQ transformation
Created sessions and workflows and set up dependencies of tasks in workflow manager
Scheduled informatica jobs and scripts using Tidal Scheduling tool
Prepared unit test cases and carried out the testing for all the scenarios
Created low-level design document that include detailed design of each component and data flow diagrams.
Extensively worked on parameter files and variables
Implemented error handling logic for writing exceptions to error tables
Created UNIX scripts for automating the Informatica jobs.
Created DDLs for new tables and updated DDLs for existing tables in the target systems in coordination with the DW architect
Attended SCRUM meetings regularly to discuss day-to-day progress of the individual teams and overall project
Environment: Informatica PowerCenter 9, Oracle 10g, UNIX, TOAD, and Tortoise SVN,Tidal
Independent health, Buffalo, NY Jan 2014 – June 2014
ETL developer consultant
The purpose of this project is to convert Child Health Plus (CHP) data into the KIDS (Knowledge, Information and Data Systems) file format so that it can be loaded to the KIDS system, and receive back a response file to know if each of the records was accepted or not. This activity is required for effectuated members as well as any changes or terminations in order to receive payment from the state.
Responsibilities:
Imported source and target definitions using Source Analyzer and Warehouse Designer components of Informatica for various source/target types: flat files, DB2, Oracle and XML
Created ETL mappings using various Informatica transformations: source qualifier, data quality, Dynamic lookups, expression, filter, router, sorter, aggregator, XML SQ transformation and XML Parser
Created sessions and workflows and set up dependencies of tasks in workflow manager
Scheduled informatica jobs and scripts using Tidal Scheduling tool
Prepared unit test cases and carried out the testing for all the scenarios
Created low-level design document that include detailed design of each component and data flow diagrams.
Extensively worked on parameter files and variables
Implemented error handling logic for writing exceptions to error tables
Created UNIX scripts for automating the Informatica jobs.
Created DDLs for new tables and updated DDLs for existing tables in the target systems in coordination with the DW architect
Attended SCRUM meetings regularly to discuss day-to-day progress of the individual teams and overall project
Environment: Informatica PowerCenter 9, Oracle 10g, UNIX, TOAD, and Tortoise SVN,Tidal
Independent Health, Buffalo, NY Sep 2013 – Jan 2014
ETL developer consultant
The objective of this project is to integrate a vendor solution that facilitates the enrollment and reconciliation processes and procedures for client’s Medicare products in accordance with CMS requirements. The overall goal of this project is to implement a system coupled with business processes that will ensure that client maintains compliance with CMS on an on-going basis.
Responsibilities:
Imported source and target definitions using Source Analyzer and Warehouse Designer components of Informatica for various source/target types: flat files, DB2, Oracle and XML
Created ETL mappings using various Informatica transformations: source qualifier, data quality, Dynamic lookups, expression, filter, router, sorter, aggregator
Created sessions and workflows and set up dependencies of tasks in workflow manager
Scheduled informatica jobs and scripts using Tidal Scheduling tool
Prepared unit test cases and carried out the testing for all the scenarios
Created low-level design document that include detailed design of each component and data flow diagrams.
Extensively worked on parameter files and variables
Implemented error handling logic for writing exceptions to error tables
Created UNIX scripts for automating the Informatica jobs.
Created DDLs for new tables and updated DDLs for existing tables in the target systems in coordination with the DW architect
Attended SCRUM meetings regularly to discuss day-to-day progress of the individual teams and overall project
Environment: Informatica PowerCenter 9, Oracle 10g, UNIX, TOAD, and Tortoise SVN,Tidal
Independent Health, Buffalo, NY Jun 2013 – Sep 2013
ETL developer consultant
The objective of this project is to meet the CMS requirements for the MSP. The combinations of client data extract program and the vendor hosted solution to send and receive data to and from Client, and submit the data required to COBC in the proper format, as well as receive and process the response files from the COBC and provide query and reporting capabilities on a centralized data repository.
Responsibilities:
Imported source and target definitions using Source Analyzer and Warehouse Designer components of Informatica for various source/target types: flat files, DB2, Oracle and XML
Created ETL mappings using various Informatica transformations: source qualifier, data quality, Dynamic lookups, expression, filter, router, sorter, aggregator, XML SQ transformation and XML Parser
Created sessions and workflows and set up dependencies of tasks in workflow manager
Scheduled informatica jobs and scripts using Tidal Scheduling tool
Prepared unit test cases and carried out the testing for all the scenarios
Created low-level design document that include detailed design of each component and data flow diagrams.
Extensively worked on parameter files and variables
Implemented error handling logic for writing exceptions to error tables
Created UNIX scripts for automating the Informatica jobs.
Created DDLs for new tables and updated DDLs for existing tables in the target systems in coordination with the DW architect
Attended SCRUM meetings regularly to discuss day-to-day progress of the individual teams and overall project
Environment: Informatica PowerCenter 9, Oracle 10g, UNIX, TOAD, and Tortoise SVN,Tidal
Independent Health, Buffalo, NY Feb 2012 – Aug 2012
ETL developer consultant
The objective of this project was to design and develop the Supplier subject area as part of the CAP initiative. This phase of the project involved converting existing source data by cleansing and transforming it by applying defined business rules.
Responsibilities:
Imported source and target definitions using Source Analyzer and Warehouse Designer components of Informatica for various source/target types: flat files, DB2, and Oracle
Created ETL mappings using various Informatica transformations: source qualifier, data quality, lookup, expression, filter, router, sorter, aggregator, and HTTP
Created sessions and workflows and set up dependencies of tasks in workflow manager
Prepared unit test cases for all mappings to test code
Created cucumber test scenarios using RubyMine
Created low-level design document that included detailed design of each component and data flow diagrams.
Extensively worked on parameter files to generalize the ETL code
Implemented error handling logic for writing exceptions to error tables
Created DDLs for new tables and updated DDLs for existing tables in the target systems in coordination with the DW architect
Attended SCRUM meetings regularly to discuss day-to-day progress of the individual teams and overall project
Environment: PowerCenter 8.6.1, Oracle 10g, UNIX, TOAD, and Tortoise SVN
Independent Health, Buffalo, NY Jun 2011 – Feb 2012
ETL developer consultant
The objective of this project was to design and develop the Practitioner subject area as part of the CAP initiative. This phase of the project involved converting existing source data by cleansing and transforming it by applying defined business rules.
Responsibilities:
Imported source and target definitions using Source Analyzer and Warehouse Designer components of Informatica for various source/target types: flat files, DB2, and Oracle
Created ETL mappings using various Informatica transformations: source qualifier, data quality, lookup, expression, filter, router, sorter, aggregator, and HTTP
Created sessions and workflows and set up dependencies of tasks in workflow manager
Prepared unit test cases for all mappings to test code
Created cucumber test scenarios using RubyMine
Created low-level design document that included detailed design of each component and data flow diagrams.
Extensively worked on parameter files to generalize the ETL code
Implemented error handling logic for writing exceptions to error tables
Created DDLs for new tables and updated DDLs for existing tables in the target systems in coordination with the DW architect
Attended SCRUM meetings regularly to discuss day-to-day progress of the individual teams and overall project
Environment: Informatica PowerCenter 8.6.1, Oracle 10g, UNIX, TOAD, and Tortoise SVN
EDUCATION AND PROFESSIONAL DEVELOPMENT
JNTU University, India
Bachelor of Engineering in Information technology
Certifications
Informatica Certified Developer
Contact this candidate