We provide IT Staff Augmentation Services!

Etl Project Lead & Etl Architect Resume

Minneapolis, MN

SUMMARY:

  • Having 11+ years of experience in full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
  • Enterprise Data Warehousing and Data mart: Experience and Expertise in ETL process (Informatica Power Center 9.x/8.x/7.x/6.x), Experience in using Informatica MDM tools like Informatica MDM Hub Console, Informatica Data Quality 8.6, Informatica Data Explorer 8.6, Informatica Analyst 9.0.1, Informatica Developer 9.0.1.
  • Experience and Expertise in ETL process (Informatica PowerCenter) Mappings, Mapplets, Transformations, Workflow Manager and Workflow Monitor. Also, Experience in Extraction / Transformation / Loading of legacy data to Data Warehouse using Informatica Developer9.0.1.
  • Experience and Expertise in Profiling, Audit balancing, Rules, Generating score cards with Informatica Data Explorer8.6 and Informatica Analyst9.0.1.
  • Expertise in creating the plans with components by IDQ8.6, mappings with transformations by Informatica Developer 9.x.
  • Expertise in implementing the JMS, MQ Messaging, Message Queue source & Targets, HTTP, XML, Web Services and HTML Transformations along with SFDC Sales force methodology.
  • Worked on Informatica B2B DT (Data Transformations), UDO & Data Exchange processes.
  • Experience and Expertise in creating Visio diagrams with Informatica power center components using Informatica Mapping Architect for visio9.0.1 and also experience in Informatica Administration & Informatica MDM Hub Console.
  • Designed and implemented Trust score, Validation rules and Merge/Match concepts with MDM.
  • Implemented MDM Fuzzy, Exact Match and Merge Rules and loaded into Match tables.
  • Implemented MDM Hub Console Packages, Cell update, Validation rules under Base Object, Stage table and XREF methodologies under MDM SIF.
  • Extensively worked on MDM Siperian Batch job schedule, Shell scripts configure & Batch viewer tools.
  • Worked on MDM Lookup tables and mappings to load ruled data into Hub BO tables.
  • Good understanding in Data warehousing Concepts with Ralph and Kimball methodologies, ODS and Staging data.
  • Worked on SOA Certificate, Web services related 1 - way SSL and 2-way SSL process.
  • Experience in designing the Batch mechanism, Audit Balancing and Counting frame works, partitioning the jobs at ETL level.
  • Expertise in identifying the Source and Target bottle necks and implementing the Performance tuning techniques at mapping, session and database level.
  • Proficiency in using Informatica Power Center tool to design Data Integration, Data Conversions, Data Migration from Multiple Source systems.
  • Extensive experience in working with HR Payroll & CRM related PeopleSoft, SAP HCM and SIEBEL sources. Also, experience in working with BOXI R2, WEBI and DESKI reporting tools.
  • Extensively worked on Databases like Oracle 11g/10g/9i/8i, SQL Scripting and also worked on large database systems.
  • Good knowledge on writing the PL/SQL Scripts like Procedures, Packages and Functions.
  • Having good knowledge on writing Shell Scripts and UNIX commands.
  • Extensively worked on Oracle E-biz, ERP & Oracle Financial data sets.
  • Testing skills include performing Unit, Regression, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
  • Experience in providing Application support engagements and On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner).
  • Good exposure with Incident and Change management processes.
  • Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
  • Worked on preparing Low level, High level design documents along with Release notes & Run book.
  • Good understanding of Product Life Cycle and Comprehensive Delivery Process’s.

TECHNICAL SKILLS:

O/S: Windows NT/XP/98/2000, Unix, Linux

ETL Tools: Informatica PowerCenter 9.6/9.0.1/8.6/7.1.1/6. x, Informatica Data Quality 8.6, Informatica Data Explorer 8.6, Informatica Developer 9.0.1, Informatica Analyst 9.0.1, Informatica Power Exchange 8.6, Informatica MDM Hub Console 9.x, Informatica Mapping Architect for Visio 9.0.1, Informatica9.0.1 Administration, Power center Web Services, Informatica Cloud, SSIS, Pentaho

Database, Languages & Tools: Oracle 11g,10g/9i/8i, Sql, Pl/Sql, SQL Server R2/2008/2012, MS-Access, Info Sphere, Teradata, BTEQ, Unix Shell Scripting, Golden gate, Oracle streams

Tools: and Utilities: Toad, Sql Developer, Putty, Samba, PVCS, SVN, UC4, Autosys, HP Quality Center11, IBM RTC, Axway, WLM, UDO, SAP

Methodologies: Star Schema, Snowflake Schema

Reporting Tools: Business Objects XIR2

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

ETL Project Lead & ETL Architect

Responsibilities:

  • Participated in Business requirements.
  • Coordinated cross-functional team efforts in meeting and exceeding goals.
  • Played a project lead role in the requirement gatherings.
  • Implemented end-to-end solution for Solace message system with Informatica.
  • Implemented JNDI and JMS frameworks within Informatica.
  • Worked on Message queue performance tuning for request and response.
  • Worked on creating Informatica mappings with different transformations like lookup, SQL, Normalizer, Web Services, XML, HTML, Aggregator, SQ, Joiner, Expression, Router…etc.
  • Worked on creating the mapplets with mapplet input and outputs by using Power center designer.
  • Worked on creating the workflows and sessions with pre/post session commands.
  • Worked on UNIX shell scripts and called them into ETL workflows by passing the input arguments.
  • Worked on creating the generic batch mechanism process and audit controls.
  • Extensively worked on performance tuning techniques and also on identifying the source, target bottlenecks.
  • Worked on DB2 procedures and query optimization.
  • Worked with SEI to get response reports and parsing.
  • Created profiles on source tables/files, and generated score cards based on rules.
  • Validated Informatica Analyst rules as mapplets and called into power center designer.
  • Worked on pl/sql procedures and oracle statements to capture the data and testing.
  • Implemented Trust concept and assigned Trust score for domain columns.
  • Prepare unit and integration test plans, code review, testing, debugging (using Debugger) and deployment of Informatica jobs into production environment.

Confidential, Minneapolis, MN

Senior ETL Project Lead

Responsibilities:

  • Participated in requirements gatherings.
  • Coordinated cross-functional team efforts in meeting and exceeding goals.
  • Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
  • Worked on creating Informatica mappings with different transformations like lookup, SQL, Normalizer, Web Services, XML, HTML, Aggregator, SQ, Joiner, Expression, Router…etc.
  • Worked on creating the mapplets with mapplet input and outputs by using Power center designer.
  • Worked on creating the workflows and sessions with pre/post session commands.
  • Worked on UNIX shell scripts and called them into ETL workflows by passing the input arguments.
  • Worked on creating the generic batch mechanism process and audit controls.
  • Extensively worked on performance tuning techniques and also on identifying the source, target bottlenecks.
  • Worked on SFTP, FTP file transfer scripts, UC4 job scheduling scripts.
  • Created Informatica mappings with transformations by using Informatica Developer.
  • Created profiles on source tables/files, and generated score cards based on rules.
  • Validated Informatica Analyst rules as mapplets and called into power center designer.
  • Worked on Address Doctor/Dictionaries to validate source data addresses and zip codes.
  • Worked on IDQ transformations like Standardizer, Distance, Weighted Average, Consolidation, Matching, Labeler, and Parser …etc.
  • Done single table structure profiling, cross table structure profiling by using Informatica Analyst.
  • Worked on Informatica analyst to identify Patterns, Frequency, Null’s on source data.
  • Worked on pl/sql procedures and oracle statements to capture the data and testing.
  • Worked on Informatica MDM Hub Console to identify the master record from multiple sources.
  • Implemented Trust concept and assigned Trust score for domain columns.
  • Increased agility and accommodate and streamline MDM by using business rules.
  • Created Exact, Fuzzy match & Enables Auto merge mechanism to cleanse the data.
  • Configured shell script to run the Siperian MDM hub jobs.
  • Designed rules and that are exposed and enforced as part of MDM batch process. And, implemented match/merge mechanism to identify the master record.
  • Implemented dashboards in Informatica Data Director and created score cards.
  • Prepare unit and integration test plans, code review, testing, debugging (using Debugger) and deployment of Informatica jobs into production environment.

Environment: Informatica Power Center 9.6, Unix, Oracle 11g, SQL Developer, Pl/Sql, UC4, Cognos, Informatica Developer9.5, Informatica Analyst9.5, Informatica Hub Console 9.6.

Confidential, Madison, WI

Senior Informatica Lead

Responsibilities:

  • Involved in translating business requirements to integrate into existing data mart design.
  • Involved in System analysis, Estimations and design for enhancements.
  • Leading as a technical lead by providing ETL Technical/Functional documents.
  • Troubleshooting and fine tuning of mappings for maximum.
  • As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
  • Interacted DBA team to make sure application data base and also created all necessary data base objects for our project in Dev and Test Environments.
  • Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
  • Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
  • Working on Informatica Developer(Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
  • Worked on writing Pl/Sql procedures in Oracle and captured those by using Informatica stored Procedures.
  • Generated Scorecards based on profile results
  • Done single table structure profiling, cross table structure profiling.
  • Created Data quality mappings (plans) and exporting those to power center as mapplets.
  • Created Rules on profiled data and used the same to data quality mappings.
  • Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.

Environment: Informatica Power Center 9.5, Unix, Oracle 10g, BOXI R2, Toad, Pl/Sql, Autosys, WLM, Informatica Dataquality8.6, Informatica Developer9.0.1, Informatica Analyst9.0.1.

Confidential, Richmond, VA

Senior Solution Engineer

Responsibilities:

  • Involved in translating business requirements to integrate into existing data mart design.
  • Coordinated cross-functional team efforts in meeting and exceeding goals.
  • Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
  • Involved in System analysis, Estimations and design for enhancements.
  • Leading as an onsite/ Confidential coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact (POC) for the Confidential team.
  • Troubleshooting and fine tuning of mappings for maximum.
  • As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
  • Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
  • Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
  • Working on Informatica Developer(Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
  • Worked on writing BTEQ scripts.
  • Generated Scorecards based on profile results
  • Done single table structure profiling, cross table structure profiling.
  • Created Data quality mappings(plans) and exporting those to power center as mapplets
  • Created Rules on profiled data and used the same to data quality mappings.
  • Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.

Environment: Informatica Power Center 9.0.1, Informatica Data Explorer8.6, Unix, Oracle 10g, BOXI R2, Toad, Pl/Sql, WLM, Informatica Dataquality8.6, Informatica Developer9.0.1, Informatica Analyst9.0.1, Teradata, SQL Server, SAS.

Confidential, Phoenix, AZ

ETL Technical Lead / Senior Application Developer

Responsibilities:

  • Coordinated cross-functional team efforts in meeting and exceeding goals.
  • Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document. Involved in System analysis, Estimations and design for enhancements.
  • Prepared LLD and HLD design for total PAS Project.
  • Leading as an onsite/ Confidential coordinator and lead team by providing ETL Technical/Functional documents.
  • Analyzing the bugs and documenting the bug details in HP Quality Center tool and resolving them.
  • Troubleshooting and fine tuning of mappings for maximum.
  • As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
  • Worked on Web services transformations to send request and get response from/through SOA.
  • Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
  • Extracted data from Payroll Systems like PeopleSoft & SAP HCM and loaded into Oracle systems.
  • Prepared shell scripts to design the batch framework and export/import concepts of ETL jobs.
  • Extracted data from excel files, high volume of data sets from data files, Oracle, SalesForce.com(SFDC) using Informatica ETL mappings and loaded to target systems.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
  • Implemented 1-way SSL and 2-way SSL certificate process for Web services Security check
  • Worked on writing Pl/Sql procedures in Oracle and captured those by using Informatica stored Procedures. Also, Used Business Objects to generate reports at policy level.
  • Created ETL Packages by using SSIS Integration tool.
  • Worked on SSIS transformations like Fuzzy, Loop, Row count & Sampling, SCD, Term Extraction & Loop..Etc.
  • Worked on SAP & Salesforce migration.
  • Prepared procedures and functions by using SQL Server and also used to extract data.
  • Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.

Environment: Informatica Power Center 9.0.1, Informatica Data Explorer8.6, Unix, Oracle 10g, Toad, Pl/Sql, Salesforce, SQL Server R2 2008, Autosys, SSIS, XML, Business Objects XIR2, Quality Center 9.2.

Implementation Year: 2012/2014.

Confidential, Shelton, CT

Informatica Lead

Responsibilities:

  • User Requirement gathering and converting the same into Functional and Technical Specifications.
  • Developed Security Standards within the Informatica Power Center.
  • Developed Mappings for loading data from Multiple Sources into Oracle tables.
  • Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
  • Used database objects like views, Partitioning for accomplishing the Complex logical situations.
  • Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
  • Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
  • Responsible for Self and Peer Review of Informatica mappings under Development Phase.
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, Router Transformation and Normalizer Transformation in Informatica.
  • Worked with Informatica mapping architect for Visio to create Visio flow with Informatica components, generated the xml, and imported the same with mapping template wizard for rather than creating same mappings.
  • Worked with Informatica Analyst to Analyze, Create profiling and scorecards on data.
  • Worked with Informatica Developer to generate set of validation codes and exported the same to Informatica power center as mapplets.
  • Prepared the test execution plan and tracking the execution plan.
  • Managed Power Center Administration Console. Responsible for Delete logs, Creating folders.
  • Done ETL mapping unit testing, UAT and also developed test plans.
  • Created and Monitored Sessions and various other Tasks such as Event-Raise Task, Event-Wait Task, Decision Task, Command Task etc. using Informatica Workflow.
  • UNIX scripts to abort the job upon critical warnings.

Environment: Informatica PowerCenter9.0.1, Informatica Developer9.0.1, Informatica Analyst9.0.1, Informatica Mapping Architect for Visio9.0.1, Oracle11g, SQL & Pl/Sql Scripting, UNIX, Windows XP/2003, PVCS, Toad.

Confidential, New York City, NY

Senior ETL

Informatica Analyst

Responsibilities:

  • Analyzed requirements and created a high level and low-level technical design for data migration through Informatica.
  • User Requirement Gathering and converting the same into Functional and Technical Specifications
  • Involved in detail design and development of mappings using Informatica power center.
  • Analyzed the Sources and Targets and designed complex mappings and Transformations.
  • Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.
  • Interact with business analysts and translate business requirements into technical specifications.
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Stored Procedure Transformation (Connected and Unconnected), Joiner Transformation, Router Transformation and Normalizer Transformation in Informatica.
  • Extensively worked data conversion and data cleansing, Designed, built and managed individual data cleansing projects.
  • Responsibilities included designing and developing complex Informatica mappings including SCD Type-II based on near Real Time architecture set to run in batch processes.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
  • Responsible in Migrating the Developed Components from Dev Environment to QA and Prod Environment.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
  • Prepare unit and integration test plans, code review, testing, debugging (using Debugger) and deployment of Informatica jobs into production environment.
  • Used Third party Scheduler tools to schedule workflows, UNIX scripts and Pl/SQL procedures.
  • Developed test plan, strategy, test scenarios and test cases and prepared the test execution plan and tracking the execution plan.

Environment: Informatica Power Center 8.6, UNIX, Oracle 10g, Pl/Sql, Windows XP/2003, Sql Developer, Samba.

Confidential, Columbus, OH

DW Consultant

Responsibilities:

  • Interacted with Business users to understand the Business requirements and created High Level Process flow, High level technical design, and Low Level technical design documents.
  • Designed Informatica process and developed mappings/Sessions/Workflows to load data from Source to Staging and from staging to Warehouse.
  • Involved in designing the data model and Prepare Process Flow Diagrams, Flow Charts, File layouts.
  • Worked on Power Center Client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Created mappings with various transformations, executed workflows with sessions through workflow manager.
  • Responsible for Self and Peer Review of Programs and Test Records under Development Phase
  • Prepare Unit, System, Integration and Load Test Plan’s, Test Specifications and Test Records under Test Planning Phase
  • Perform Unit, System, Integration and Load Testing under Testing Phase and simultaneously reviewing and Recording the Test Results.
  • Designed and developed transformation rules to generate consolidated data using Informatica ETL (Power Center) tool.
  • Created Informatica mappings, batches and session and Scheduled jobs with UC4 scheduling tool.
  • Worked extensively on Flat files as the data from various legacy systems are Flat files.
  • Used Partitioning techniques to improve session performance.
  • Used Parameter Files defining variable values for mapping parameters and variables.
  • Involved in data cleansing using Trillium data analytics, matching, standardization, and cleansing routines.

Environment: Informatica Power Center8.6, SQL Scripting, Oracle10g, SAS, Cognos, UC4, Putty, SQL Developer, Flat files, Windows XP/2000.

Confidential, Orlando, FL

ETL Developer

Responsibilities:

  • Extensively used ETL to load data from Flat Files and Oracle database.
  • Developed data Mappings between source systems and warehouse components using Mapping Designer.
  • Worked extensively on different types of transformations like source qualifier, expression, Filter, aggregator, update strategy, lookup, stored procedure and joiner.
  • Extensively worked data conversion and data cleansing, Designed, built and managed individual data cleansing projects.
  • Done Data cleansing, analysis and analyze the patterns with Data Explorer and generating reports and logs.
  • Developed Data Quality plans with Different Components and publish the Plans to Informatica Power center through mapplets.
  • Created, launched & scheduled sessions. Involved in Performance Tuning of Informatica.
  • Extensively Worked with External Loader (Fast Load) connections through workflow manager to load the Target tables.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Developed test procedures to compare the aggregates of source and target databases.
  • Created packages and procedures to clear the target table duplicates.
  • Worked on SAP HCM systems to process the HR & Payroll data.
  • Mappings were designed to cater the slowly changing dimensions (S.C.Ds).
  • Developed Standard report template which will be used as a standard for development and UI testing.

Environment: Informatica PowerCenter8.6, Informatica Data Quality8.6, Informatica Data Explorer8.6, Oracle 9i, Windows NT 4.0, Toad, Pl/Sql

Confidential

EDW Analyst

Responsibilities:

  • Involved in detail design and development of mappings using Informatica power center.
  • Done data quality and comprehensive data cleansing and parsing capabilities, which enable data analysts and data stewards to standardize, validate, enhance, and correct all types of enterprise data
  • Used Source Analyzer and Warehouse Designer to import the source and target database schemas. Implemented performance tuning techniques at mapping level.
  • Used mapping designer to map source to the target with required Business logic.
  • Used Transformation Developer to create the Joiner, filters, lookups, Expressions and Aggregation transformations that are used in mappings.
  • Developed reusable mapplets using mapplet designer.
  • Created and executed Workflows using Informatica Workflow Manager.
  • Created Changed Data Capture tables to extract the incremental data.
  • Prepared the test execution plan and tracking the execution plan.
  • Done ETL mapping unit testing, UAT and also developed test plans.

Environment: Informatica 7.1.1, Oracle 8i, Toad, Flat files, Microsoft Windows NT

Hire Now