Sr.etl Informatica Developer Resume
PhoeniX
PROFESSIONAL SUMMARY:
- 8 Years of IT Experience in Software Design, Development, Testing and Deployment using SDLC and Agile methodologies.
- Adept at all phases of SDLC, which includes Design, Analysis, Coding, Testing, Code Reviews, Implementation and System Support.
- Data processing noledge in designing and implementing Data Warehouse applications, mainly Transformation processes using ETL tool Informatica Power Centre 9.6/9.1/8.6.1/8.1.1/7.1.2 .
- Working Experience wif Master Data Management (MDM)
- Working experience in Development, Enhancement and migration projects.
- Has involved in end to end project activities i.e. from gathering Business needs, converting them into requirements, analysis, design activities, build to testing phases, reviews and in release management.
- Extensively used Informatica for ETL purposes on various sources and targets like Flat files, Oracle, SQL Server, XML, Mainframes DB2, Netezza,Bigdata and IBM DB2,SAP.
- Extensively worked on Designer, Repository Manager, Workflow Manager and Workflow Monitor using Informatica ETL Tool.
- Sound noledge in administration tasks including importing/exporting mappings, copying Workflow objects.
- Strong experience using Oracle, DB2, MS SQL Server, Netezza,Data Modular XML.
- Proficient in understanding business processes / requirements and translating them into technical requirements,Exposure on B2B process.
- Expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement teh business logics of database in Oracle.
- Experience in Unix Shell scripting and Perl Scripting and Linux.
- Worked wif Data Architect and DBA in preparing Logical and Physical data models.
- Strong in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies, slowly changing Dimensions.
- Working experience in Informatica Uplift from 9.1 to 9.6.1.
TECHNICAL SKILLS:
ETL Tools: Informatica 9.6/9.1/8.6/ 8.1/7.1, SSIS
BI/OLAP Tools: SSRS, Crystal Reports, Cognos 10.1
Data Modeling: Dimensional Data Modeling, using Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN
Databases: Oracle, DB2, Netezza, SQL Server
Programming languages: C, C++
Scripting: Unix Shell scripting, SQL stored procedures
PROFESSIONAL EXPERIENCE:
Confidential, Phoenix
Sr.ETL Informatica Developer
Responsibilities:
- Extensively involved in almost all teh phases of Project life cycle right from Requirements Gathering to Testing etc.
- Involved in data design and modeling by specifying teh physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
- Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
- Actively involved in gathering requirements from teh end users.
- Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and sql server tables to target tables.
- Worked wif various transformations to solve teh Slowly Changing Dimensional Problems using Informatica Power Center
- Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored teh results in Workflow monitor.
- Did performance tuning at source, transformation, target, and workflow levels.
- Parameterized teh mappings and increased teh re - usability
- Used transformations such as teh source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
- Experience in using Debugger in Informatica Designer tool to test and fix errors in teh mappings
- Responsible for creating shared and reusable objects in Informatica shared folder and update teh objects wif teh new requirements and changes.
- Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
- Worked wif BIDW Admin Team for Code Migration between Development, Test and Production Repositories.
- Supported teh Quality Assurance team in testing and validating teh Informatica workflows.
- Did unit testing and development testing at ETL level in my mappings.
Environment: Informatica Power Center 9.6, UNIX, DB2, Netezza, SQL Server
Confidential, Phoenix
Sr .ETL Informatica Developer
Responsibilities:
- Proficient in understanding business processes/requirements and translating them into technical requirements
- Worked wif Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
- Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
- Actively involved in gathering requirements from teh end users.
- Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files, xml and RDBMS tables to target tables.
- Worked wif various transformations to solve teh Slowly Changing Dimensional Problems using Informatica Power Center
- Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored teh results in Workflow monitor.
- Schedule ETl loads using Control M.
- Resolve Critical and high incidents wifin time frame.
- Did performance tuning at source, transformation, target, and workflow levels.
- Used PMCMD, and UNIX shell scripts for workflow automation.
- Parameterized teh mappings and increased teh re-usability
- Used transformations such as teh source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
- Checked and tuned teh performance of application.
- Responsible for creating shared and reusable objects in Informatica shared folder and update teh objects wif teh new requirements and changes.
- Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
- Created RFCs and worked wif BIDW admin team on Migration between Development, Test and Production Repositories.
- Supported teh Quality Assurance team in testing and validating teh Informatica workflows.
- Did unit testing and development testing at ETL level in my mappings.
Environment: Informatica Power Center 9.1, Netezza,UNIX, Webfocus,IBM DB2, Xml, flat files
Confidential, Phoenix
Sr InformaticaDeveloper
Responsibilities:
- Proficient in understanding business processes/requirements and translating them into technical requirements
- Worked on Power Center Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
- Extracting,transforming and validating teh data and loading teh data into Stage Database Netezza And finally load teh Data in to DB2.
- Extensively used transformations like Application source Qualifier, Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
- Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
- Involved in teh debugging of teh mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
- Created and scheduled Worklets, created many reusable tasks and used them in different Worklets and Workflows.
- Scheduled teh Loading processes and monitored sessions using Informatica Workflow Monitor.
- Extensively worked in teh performance tuning of mappings and sessions.
- Responsible for Testing and validating teh Informatica mapping against teh pre-defined ETL design standards.
- Created teh Unit Test Plans and did Unit Testing, Prepare teh Unit Test logs.
- Successfully moved teh Mappings, Sessions and workflows from teh Development environment to Production environment.
- Monitoring execution of implemented job in production during teh warranty period and fix teh identified issues.
- Provide noledge transfer and process documents to Production Support for ongoing maintenance of teh code.
- Completed documentation in relation to detailed work-plans, mapping documents and high-level data models.
Environment: Informatica 9.1, DB2, UNIX Shell Scripting, Netezza
Confidential, Phoenix
Informatica Developer
Responsibilities:
- Proficient in understanding business processes/requirements and translating them into technical requirements
- Worked on PowerCenter Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
- Extracting teh data from Mainframe DB2 tables, transforming and validating teh data and loading teh data into Central Data Warehouse DB2 database.
- Designed, developed mappings, enabling teh extract, transport and loading of teh data into target tables.
- Extensively used transformations like Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
- Developed standard and reusable mappings and mapplets.
- Tuned teh SQL queries used in teh SQL override, Lookup Override of teh Source Qualifier and Lookup transformations.
- Involved in teh debugging of teh mappings by creating breakpoints to gain troubleshooting information about data and error conditions
- Created and scheduled Worklets, created many reusable tasks and used them in different Worklets and Workflows.
- Scheduled teh Loading processes and monitored sessions using Informatica Workflow Monitor.
- Analyzing and modifying teh existing PL/SQL Packages for performance tuning.
- Extensively worked in teh performance tuning of mappings and sessions.
- UNIX Environment for running jobs through Control M.
- Responsible for Testing and validating teh Informatica mapping against teh pre-defined ETL design standards.
- Created teh Unit Test Plans and did Unit Testing, Prepare teh Unit Test logs.
- Successfully moved teh Mappings, Sessions and workflows from teh Development environment to Production environment.
- Completed documentation in relation to detailed work-plans, mapping documents and high-level data models.
Environment: Informatica 8.6, DB2, UNIX.
Confidential
ETL Developer
Responsibilities:
- Proficient in understanding business processes / requirements and translating them into technical requirements.
- Extensively used Informatica to extract data from various Operational Systems, External Systems and Staging Area.
- Used heterogeneous data sources, like flat files and Oracle.
- Applied Complex Mappings and various Transformations (Filter, Router, Lookup, Update Strategy, and Expression) on teh extracted data according to teh Business Rules and Technical Requirements.
- Created mappings using teh transformations such as teh Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
- Worked on connected as well as unconnected Lookup transformation to look up values in a table.
- Creating reusable transformations and mappings using Informatica.
- Used debugger to test teh data flow and fix teh mappings.
- Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks, created and monitored Informatica sessions.
Environment: Informatica PowerCenter 8.1, Oracle 9i, UNIX.
Confidential
ETL Developer
Responsibilities:
- Proficient in understanding business processes / requirements and translating them into technical requirements.
- Extensively used Informatica to extract data from various Operational Systems, External Systems and Staging Area.
- Worked extensively in Informatica in developing mappings and workflows.
- Created mappings according to teh business rules.
- Good noledge on using teh debugger in case of any bugs.
- Created workflows and run teh sessions using workflow designer.
- Creation of detail design documents and unit test plans.
- Unit testing and integration testing of mappings and workflows.
- Taken care Mandatory Checks, Date Field checks and Number Field Checksin Informatica
Environment: Informatica PowerCenter 8.1, Oracle 9i, UNIX.