We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer/administrator Resume

DC

SUMMARY:

  • Over 12+ years of IT experience in analysis, design, development and implementation of Data Warehouse and software applications using ETL tool Informatica Power center, Reporting tool Business Objects and ERWIN.
  • Experience with Star Schema/Snowflake Schema, FACT & Dimensions tables, physical & logical data modeling using Erwin 7.1/4.2/3.5
  • Excellent knowledge and experience in Data Warehouse Development Life Cycle, Requirements Analysis. Involved in the implementation of Slowly Changing Dimensions Type I, Type 2.
  • Experience in creating complex mappings using various transformations, and development strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica Power Center 8.5.1/8.1.1/7.1.3/7.1.1 (Designer, Transformation developer, Repository manager, Workflow manager, Mapplets/Transformations/ Pmcmd) to create, schedule and control workflows, and sessions.
  • Experience with Clear Case, Clear Quest and MS Word.
  • Experience in Performance Tuning of sources, transformations, targets, mappings, worklets, workflows and sessions.
  • Automated and scheduled the Informatica jobs using UNIX shell scripting, AutoSys, and Control M.
  • Experience in source systems data analysis and data extraction from various sources like Oracle 11g/10g/9i/8i, Teradata V2R4/V2R3, DB2 UDB 7.2, MS SQL Server 2005/2000.
  • Extensive experience in writing SQL and PL/SQL programs Stored Procedures, Functions, Packages, triggers and creation of Tables and Indexes for back end development.
  • Responsible for loading data into warehouse from different sources using SQL*LOADER.
  • Understanding and writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD, Fast Export and TPUMP utilities.
  • Used Teradata Queryman and Query Analyzer to check the data consistency in the tables and for performing Adhoc Queries.
  • Good Experience in developing detailed test cases, scenarios and conditions, building test data, entering/tracking and retesting defects.
  • Used Pervasive Integration tool to integrate data from variety of sources and implementing business rules/data validations using RIFL scripts.
  • Experience in DSS/OLAP tool Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.
  • Provided Production support, performed Document reviews, prepared Detailed Design, Test Plan, Promotion, Change Request, Maintenance and Check List documents.
  • Team player with creative problem solving skills, quick learning skills, self - starter with good communication skills and ability to work independently or as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica (9.6.1)/ (8.6.1), OWB Release 2, Pervasive Integration 9G

Reporting Tool: Business Objects 6.5.1, XIR3/Crystal report Xi

Languages: SQL, PL/SQL

RDBMS: Oracle 9i, TeradataV2R5, UDB DB2, MS SQL Server 7.0/2000

Data Modeling: Erwin 4.0/3.5

Interfaces: Teradata Quarryman, MS SQL Server Query Analyzer, Vi EditorToad 7.2.0, AQT 6.1.7, Microsoft Visio, Quick Base

Configuration Management Tool:: Rational Clear Case, Clear Quest

Operating Systems: Windows 2000/XP/NT Server 7.0/2000

PROFESSIONAL EXPERIENCE:

Confidential, DC

Sr. ETL Informatica Developer/Administrator

Responsibilities:

  • In DCAS (District of Columbia Access System) lead a team of ETL developers including hands-on and advisory capacity to deliver a ETL project, Performed architectural reviews and design reviews for ETL solutions.
  • Performance tuned ETL mappings and streamlining requirements with design, handled design calls with clients and prepared Design documents (High level design), estimations, was involved in mapping business requirements into technical specification and providing architectural solutions.
  • Mentored team members in best practices in Informatica Mappings and Sessions development, created test scripts to facilitate end-to-end testing of ETL processes, Proficient in writing SQL queries, Performance Tuned Oracle/SQL/queries and Informatica ETL’s, Proactive in analyzing and troubleshooting problems, was involved in analyzing system issues to identify data related issues.
  • Interacted with client SME studied & analyzed the client applications and provided them with solutions to the problems with architecture.
  • Involved in architecture design, development and implementation of backup and recovery systems.
  • Implemented the encryption and decryption of files to meet the security requirements.
  • Co-ordinated with different external agencies to gather the interface requirement. Worked on integration of ETL integration with ESB.
  • Developed and Unit Tested the Interfaces developed in Dev environment.
  • Migrated the QA signed-off code to higher environment like UAT, Pre-Prod & Prod
  • Created Notices and handled defect fixing in production support.
  • Worked on enterprise scheduler to schedule the batch jobs across all applications.
  • Worked in Performance Tuning of sources, transformations, targets, mappings, worklets, workflows and sessions.
  • Performed Troubleshooting/debugging at different stages in database, workflows and mappings
  • Performed data manipulations in Informatica using various transformations like Expression, Source Qualifier, Filter, Joiner, Aggregator, Connected/Unconnected Lookup, Router, and Update Strategy.
  • Worked in building and managing various data warehousing/data marts using Informatica. Created complex mappings using various transformations, and development strategies for Extraction, Transformation and Loading (ETL) mechanism

Environment: Informatica (Power Center/Power mart 9.5.1), Oracle 11g, SQL Server, PL/SQL, Micro strategy, UNIX (shell scripting), Toad

Confidential, Hanover, MD

Sr. ETL Informatica Developer

Responsibilities:

  • Enhancements to Framework design of existing DMRPT to provide a means to obtain and report total spread including adjustments at summary levels (aggregates in addition to the existing facts). The requirement is to accomplish the above rapidly to support the TEK demonstrations of the prototype.
  • Involved in developing High Level Design and Low-Level Design Documents.
  • Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables, Summary tables, etc.,
  • Design and developed complex mappings to extract the data from source from files and loaded into XML files.
  • Extracted data from heterogeneous sources like Oracle, Siebel, SalesForce.com and loaded into Staging area.
  • Tuned mappings, procedures and scripts when doing complex data loads for better performance
  • Created complex mappings to load data to Data Marts, like Incremental loading, Constraint Based Loading, Target Load Plan, Pre/Post SQL, Normalization, Denormalization, etc.,
  • Converted SSIS packages into Informatica Mappings.
  • Installed and Worked with Force.com Explorer to view Salesforce data. Used SQL query language.
  • Used transformations like Expression, Lookup, Filter, Router, SQL, Union, Normalizer, Sequence Generator, Joiner, Aggregator, Sorter, Stored Procedure, Update Strategy
  • Created and Used shortcuts for sources, targets, reusable lookups, mapplets, etc.,
  • Experience working in Team based environment (Versioned Informatica Repository)
  • Unit tested the code and closely worked with testing team members in resolving the defects.
  • Extensively used mapping parameters and variables to reuse the code.
  • Developed Mapplets and reusable transformations to share the code with the team and reuse business logic.
  • Wrote and implemented generic UNIX and FTP Scripts for various purposes like running workflows, archiving files, to execute SQL commands and procedures, move inbound/outbound files.
  • Actively participated in the code review process and provided inputs to the team members

Environment: Informatica (Power Center/Power mart 9.6.1), Oracle 11g, SQL Server, PL/SQL, Altova XML Spy, UNIX (shell scripting), Toad

Confidential

Sr. ETL Developer

Responsibilities:

  • Enhancements to Framework design of existing DMRPT to provide a means to obtain and report total spread including adjustments at summary levels (aggregates in addition to the existing facts).
  • Involved in developing High Level Design and Low Level Design Documents.
  • Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables, Summary tables, Rolling tables, etc.,
  • Extracted data from heterogeneous sources like Oracle, Siebel, SalesForce.com and loaded into Staging area.
  • Tuned mappings, procedures and scripts when doing complex data loads for better performance
  • Created complex mappings to load data to Data Marts, like Incremental loading, Constraint Based Loading, Target Load Plan, Pre/Post SQL, Normalization, Denormalization, etc.,
  • Used transformations like Expression, Lookup, Https, Filter, Router, SQL, Union, Normalizer, Sequence Generator, Joiner, Aggregator, Sorter, Stored Procedure, Update Strategy
  • Created and Used shortcuts for sources, targets, reusable lookups, mapplets, etc.,
  • Implemented the PMCMD command to run the workflows through Unix shell scripts and job automation using Autosys scheduling tool.
  • Develop Unix Shell Scripts to call the oracle scripts.
  • Experience working in Team based environment (Versioned Informatica Repository)
  • Followed Informatica Best Practices and Naming Conventions while developing the mappings, sessions and workflows.
  • Worked closely with Validation team to resolve mapping defects.
  • Unit tested the code and closely worked with testing team members in resolving the defects.
  • Extensively used mapping parameters and variables to reuse the code.
  • Developed Mapplets and reusable transformations to share the code with the team and reuse business logic.

Environment: Informatica (Power Center/Powermart 9.5.1/ 9.1.0 ), Power exchange, Oracle 11g, PL/SQL, UNIX (shell scripting), Toad

Confidential, MD

Sr. ETL Developer

Responsibilities:

  • Involved in requirements gathering, data modeling and designed Technical, Functional and ETL Design documents
  • Worked closely with ETL Lead and Data Modelers in converting Business Requirements into Technical Specifications.
  • Excellent knowledge in developing ETL program for supporting Data Extraction, Transformation and Loading using Informatica Power Center and possess knowledge of Informatica tools such as Power Exchange, Power Analyzer, Power Connect, Data Mart, OLAP and OLTP.
  • Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables, Summary tables, Rolling tables, etc.,
  • Developed Workflows using task developer, and working with tools like Informatica Server, Repository Manager, designer, Workflow manager and workflow monitor.
  • Extracted data from heterogeneous sources like Oracle, SQL Server and loaded into Staging area.
  • Extensive knowledge of full life cycle development in Data warehousing projects using Informatica Power Center (7.1.3/8.6.1 )
  • Created complex mappings to load data to Data Marts, like Incremental loading, Constraint Based Loading, Target Load Plan, Pre/Post SQL, Normalization, Denormalization, etc.,
  • Hands on experience in Performance tuning involving source level, target level and map level identifying and resolving performance bottlenecks
  • Studied the existing OLTP system(s), analyzed and created Facts, implementing Data warehousing solutions involving Dimension modeling with Star and Snow Flakes Schema.
  • Designed and executed test scripts to validate end-to-end business scenarios.
  • Created session tasks and managed database connections and scheduled workflows.
  • Created and worked with generic stored procedures for various purposes like truncate data from stage tables, insert a record into the control table, generate parameter files etc..
  • Resolved complex technical and functional issues/ bugs identified during implementation, Testing and post production.
  • Followed Informatica Best Practices and Naming Conventions while developing the mappings, sessions and workflows.
  • Developed UNIX UC4 scripts as part of automation.
  • Developed SQL scripts and writing oracle SQL and PL-SQL procedures, functions triggers and packages, Indexes, Hints, Partitions, Cursors and Views for processing business logic.
  • Unit tested the code and closely worked with testing team members in resolving the defects.
  • Extensively used mapping parameters and variables to reuse the code.
  • Developed Mapplets and reusable transformations to share the code with the team and reuse business logic.
  • Experienced on various RDBMS like Teradata, DB2, Oracle 11g/10g/9i, SQL server and MS-Access.
  • Actively Participated in the code review process and provided inputs to the team members

Environment: Informatica (Power Center/Powermart 9.5.0), Oracle 11g, PL/SQL, UNIX (shell scripting), Toad

Confidential, Hanover, MD

Sr. ETL Developer

  • Enhancements to Framework design of existing DMRPT to provide a means to obtain and report total spread including adjustments at summary levels (aggregates in addition to the existing facts). The requirement is to accomplish the above rapidly to support the TEK demonstrations of the prototype.
  • Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables, Summary tables, etc.,
  • Extracted data from heterogeneous sources like Oracle, Siebel, SalesForce.com and loaded into Staging area.
  • Excellent knowledge in developing ETL program for supporting Data Extraction, Transformation and Loading using Informatica Power Center and possess knowledge of Informatica tools such as Power Exchange, Power Analyzer, Power Connect, Data Mart, OLAP and OLTP.
  • Extensive knowledge of full life cycle development in Data warehousing projects using Informatica Power Center (7.1.3/8.6.1 )
  • Tuned mappings, procedures and scripts when doing complex data loads for better performance
  • Created complex mappings to load data to Data Marts, like Incremental loading, Constraint Based Loading, Target Load Plan, Pre/Post SQL, Normalization, Denormalization, etc.,
  • Converted SSIS packages into Informatica Mappings.
  • Developed Workflows using task developer, and working with tools like Informatica Server, Repository Manager, designer, Workflow manager and workflow monitor.
  • Used transformations like Expression, Lookup, Filter, Router, SQL, Union, Normalizer, Sequence Generator, Joiner, Aggregator, Sorter, Stored Procedure, Update Strategy
  • Created and Used shortcuts for sources, targets, reusable lookups, mapplets, etc.,
  • Experience working in Team based environment (Versioned Informatica Repository)
  • Wrote and implemented generic UNIX and FTP Scripts for various purposes like running workflows, archiving files, to execute SQL commands and procedures, move inbound/outbound files.
  • Experienced on various RDBMS like Teradata, DB2, Oracle 11g/10g/9i, SQL server and MS-Access.
  • Actively participated in the code review process and provided inputs to the team members

Environment: Informatica (Power Center/Powermart 9.1.0), Oracle 11g, PL/SQL, UNIX (shell scripting), Toad

Confidential, Gaithersburg, MD

ETL Developer

Responsibilities:

  • Analyzed the existing system and done modifications to implement new logic.
  • Coordinated with source system users, and monitored ETL process on a daily basis.
  • Performed data manipulations in Informatica using various transformations like Expression, Source Qualifier, Filter, Joiner, Aggregator, Connected/Unconnected Lookup, Router, and Update Strategy.
  • Involved in creating sessions, configuring and testing sessions, workflows and various tasks using Informatica workflow manager.
  • Developed Workflows using task developer, and working with tools like Informatica Server, Repository Manager, designer, Workflow manager and workflow monitor.
  • Studied the existing OLTP system(s), analyzed and created Facts, implementing Data warehousing solutions involving Dimension modeling with Star and Snow Flakes Schema.
  • Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
  • Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
  • Extensively used Informatica Power Exchange data maps for pulling Changed Data Capture (CDC) from Oracle 10g tables.
  • Applied performance tuning on targets, sources, mappings and sessions.
  • Used Pervasive Integration tool for integrating data from variety of sources and implementing business rules/data validations using RIFL scripts.
  • Involved in Performance Tuning of the Mappings, SQL statements, and used Explain Plan utilities for Optimum Performance.
  • Ran the SQL scripts through UNIX shell scripts.
  • Supported production systems as required by optimizing performance, resolving production problems, and providing timely follow-up on problem reports.

Environment: Informatica Power Center 8.6.1, Business Objects XiR3, Oracle 10g, Server 2008, SQL*Plus, SQL*Loader, Unix Shell Scripting, Windows XP

Hire Now