We provide IT Staff Augmentation Services!

Senior Informatica Etl Consultant Resume

4.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY:

  • 10 years of experience focusing on Business Intelligence/Data Warehouse/Data mart, ODS, OLTP and OLAP implementations using Informatica Power center, IDQ and Confidential, Oracle PL/SQL, SQL Server
  • Involved in the activities including but not limited to project scope, Analysis, Requirements gathering, Design, Build, System testing, UAT, Implementation and production support.
  • As a Senior Informatica consultant participating in Planning and Analysis with Client team, Solution Architects. Fit/ Gap Analysis.
  • Data modeling, ER Designs, Database object modifications.
  • As a Lead Developer, coordinating between Clients, External Vendors, Environment Team, DBA, and Application Support for Informatica ETLs development/testing, and reporting the project/deliverable status to Senior Project leadership.
  • Finalizing technical component inventory for Informatica ETLs/Interfaces/Database changes, estimating the integration work effort for Design, Build, and Testing & Deployment Activities.
  • Planning, distribution, Leading and performing work efforts for Development team. (Leading On - site and Offshore Development teams)
  • Hands on Design/Build/Unit Testing.
  • Worked on Client facing roles.
  • Defect Triage lead, tracking the entire defect life cycle.
  • Responsible for creation of project artefacts including Work plan, RICEF, High level & Detail level designs, DFDs, ETL designs, Impact Analysis Documentation and ETL test scripts, trackers, status reports, service introduction documents.
  • Good exposure to Telecommunications, Finance and Energy Domain.
  • Excellent interpersonal and customer relational Skills. Enthusiastic and a self-starter with a need of minimal input.
  • Identifying the data integration points between various systems, determining the no of ETL interfaces and Batch Schedules to enable the data movements.
  • Creating/modifying the ER Model and identifying database level changes to support the Integration. Strong with relational database design concepts.
  • Experience with dimensional modeling using star schema and snowflake models.
  • Strong experience in Extraction, Transformation and Loading data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange as ETL tool on Oracle, DB2,SQL Server Databases, MS Access, Cobol sources, Mainframe sources, XMLs, Flat Files.
  • Usage of power center transformations including but not limited to Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy, transaction control, Java, SQL, User Defined, Web Services to meet business logic in the mappings.
  • Usage of Informatica Data Quality, Address Doctor, Identity Resolution.
  • Efficient usage of Re usability and Parameterization techniques in the ETLs. Efficient usage of verbose mode/Debugger Mode for Route Cause Analysis of data issues.
  • Performed the performance and tuning Confidential source, Target levels using Indexes, Hints, Parallel processing and Partitioning on Database as well as in Informatica.
  • Experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Unix/Shell scripting, Perl Scripting.
  • Worked on Design Build Unit testing and deployment of Power Exchange Confidential ETLs.
  • Creation of Batch schedules using scheduling tools such as CA workload Automation, Autosys for daily production runs.
  • Worked on the Deployment plans and activities for Confidential, QA and production deployment.
  • Worked on different aspects of ‘Continuous Improvement Programs’ across multiple projects. Key Contributions include,
  • Studied the current batch processing schedules and identified the opportunities for performance Improvement and implemented the batches for efficient execution which decreased the SLA by 4 hours.
  • Identified the Opportunities for optimizing the maintenance of Informatica Confidential ETLs. Implemented 'Cold Start' batch jobs for more than 170 ETLs to facilitate the Sanity testing of Confidential data replication after every maintenance activity.
  • Created re-usable data replication verification scripts which brought down the sanity testing duration from 3 hours to 15 minutes.
  • Automated the data verification process by creating reusable Informatica ETLs to tie the data, especially dollar amount value after the load is performed.
  • Handled critical module of ETLs which feed Customer Billing Applications. Analyzed the open production issues and fixed also recommended workarounds to the upstream applications which fixed the Billing issues (missing Customers, Billing Dates) in downstream systems result of which more than $6 million revenue was saved.
  • Created re-usable assets which were shared across projects. Created the Best Practices handbook for Informatica Coding standards, this was used as ‘QA Checklist’ across the projects.
  • Automated the QA Checklist using Informatica to generate the Code review reports.
  • Informatica certified professional for Power Center Data Integration 9.x: Developer Specialist.
  • More than 10 Confidential Recognition awards for various contributions Confidential project level.

TECHNICAL SKILLS:

  • Informatica 9.6.1 Power center, Power exchange ( Confidential ),IDQ
  • Data warehousing
  • Relational Data Modeling/Dimensional Data Modeling
  • Extract Transform Load
  • Oracle, Teradata
  • Microsoft SQL Server, DB2
  • SQL, PLSQL, Stored Procedures
  • TSQL
  • Batch Scheduling tools (CA Workload Automation (ESP), Autosys)
  • Unix, Perl Scripting and Shell Scripting
  • HP Quality Center.
  • Software Development Life Cycle, Agile Methodology.
  • Toad, MS Sql Server Management Studio, Visio
  • IBM Web sphere Cast Iron ETL tool
  • C, C++, Java, XML,HTML,.NET
  • Business Objects Data Services
  • Business Objects XI R2
  • Distributed Order Management System(DOM)
  • Singl.eView Convergent Billing

PROFESSIONAL WORK EXPERIENCE:

Confidential, Charlotte, NC

Senior Informatica ETL Consultant

Responsibilities:

  • As Senior Informatica ETL Consultant and Lead developer participating in Planning and Analysis with Client team, Solution Architects. Fit/ Gap Analysis.
  • Data modeling, ER Designs
  • As a Lead Developer, coordinating between Clients, External Vendors, Environment Team, DBA, and Application Support for Informatica ETLs development/testing, and reporting the project/deliverable status to Senior Project leadership
  • Finalizing technical component inventory for ETLs and Interfaces, estimating the integration work effort for Design, Build, and Testing & Deployment Activities.
  • Coordination with offshore resources, mentoring, work planning/assignment for team members and leading the Design, Build, Unit Test and deployment efforts.
  • Hands on Design, Build, Unit Test and deployment of Informatica ETLs and batch schedules.
  • Review of deliverables, provide inputs, address roadblocks, monitoring progress and ensuring the complete documentation of work efforts.
  • Used Informatica 9.6.1 to integrate multiple source systems such as Oracle, flat files, XML files, DB2, MS SQL Server including development of more than 120 ETLs which involved complex transformations.
  • Worked on configuring SFTP and Encryption Decryption for transfer of files.
  • Worked on creating new Staging DataMart, Schema, tables, triggers and Views using PLSQL in Oracle.
  • Worked on Database changes of Tables and Views.
  • Implemented several ETL Load Types such as SCD2, SCD3, CDL, and FCL.
  • Responsible for creation of various project Artefacts such as, Interfaces Approach, Data Conversion Approach, Work Planning Estimator, Design/Build tracker, High level and Detail Level Designs.
  • Created and Presented Interface Approach for the whole project in front of project leadership and stake holders.
  • Created and Presented Data Conversion/Translation approach for merger of two big Energy Companies in front of project leadership and stake holders.
  • Working with Infrastructure team, for project environment and resource needs and signing off Environment Specifications Document.
  • Code review/QA Readiness, Service Introduction and Handoff to Operations Support.
  • Performed deployment/go-live activities, Warranty support activities/Impact analysis for production Support.

Confidential, Charlotte, NC

Senior Informatica ETL Consultant

Responsibilities:

  • As Senior Informatica ETL Consultant and Lead developer participating in Planning and Analysis with Client team, Solution Architects. Fit/ Gap Analysis.
  • Data modeling, ER Designs
  • As a Lead Developer, coordinating between Clients, External Vendors, Environment Team, DBA, and Application Support for Informatica ETLs development/testing, and reporting the project/deliverable status to Senior Project leadership
  • Finalizing technical component inventory for ETLs and Interfaces, estimating the integration work effort for Design, Build, and Testing & Deployment Activities. .
  • Leading the offshore team of developers, mentoring, work planning/assignment for team members and monitoring progress,
  • Review of deliverables, provide inputs, and address roadblocks and track deliverables and ensuring the complete documentation of work efforts.
  • Hands on Design, Build, Unit Test and deployment of Informatica ETLs and batch schedules
  • Used Informatica 9.6.1 to integrate multiple systems such as Oracle, SQL Server, Power plant, Flat Files, Power Exchange which involved development of more than 200 ETLs.
  • Worked on creating new Staging DataMart, Schema, tables, triggers and Views using PLSQL in Oracle.
  • Worked on Database changes of Tables and Views.
  • Efficient usage of Session Properties and CA workload automation application to automate the Cold Start of 170 ETLs.
  • Efficient automation of testing/verification of real time data replication, by creating SQL scripts, which brought down the time required to verify from several hours to 15 minutes in Production.
  • Implemented several ETL Load Types such as Power Exchange Real Time Replication, SCD2, SCD3, CDL, and FCL.
  • Creation of Impact Analysis Documents, Data Flow Diagrams for Fact, Dimension, and reference Data loads.
  • Code review/QA Readiness, Service Introduction and Handoff to Operations Support
  • .Performed deployment/go-live activities, Warranty support activities/Impact analysis for production Support.

Confidential, Charlotte, NC

Senior Informatica ETL Consultant

Responsibilities:

  • Played role as an Informatica Lead Develop and Primary P.O.C responsible for managing work of onshore and offshore resources and tracking the status
  • Designed and developed complex ETL implementations using Informatica Power Center Transformations such as Normalizers, Transaction Control, Java, Update strategy, SQL, UDF, Lookups, Sorter, Router.
  • Data Analysis to identify the source systems, Creation of ER Model, DB objects to enable the integration.
  • Worked on Business Objects Data Services ETLs to customize the vendor delivered features to support the client needs.
  • Responsible for coordinating with Architects, Business Analysts to understand the requirements and conducting workshops.
  • Responsible for coordinating with Client Team, Confidential and Vendor teams around the program.
  • Worked on Perl Scripting to support the file transfers between different servers.
  • Responsible for creation of project artefacts including work plan, RICEF, ETL designs and trackers, status reports, service introduction documents.
  • Designing the De-Commission plan along with the client solution architect for the decommission of existing interfaces.
  • Automated all ETL executions using Batch Scheduling tools such as CA Workload Automation.
  • Communicating project risks, issues, time lines, solutions, and status to the leadership.
  • Being Onshore Lead, daily coordination with Offshore resources, conducting review sessions, mentoring, work planning/assignment for team members and monitoring progress.
  • Performed performance testing and provided guidance to the team to tune ETLs to handle high data volumes.
  • Performed deployment/go-live activities and production warranty support.

Confidential, Charlotte, NC

Senior Informatica ETL Consultant

Responsibilities:

  • Understanding the Existing Finance Hub Architecture, Business requirements and prepare the functional specification document as per the Client requirements.
  • Estimation of ETL work/Interfaces, Responsible for creation of project artefacts including work plan, RICEF, ETL designs and trackers, status reports, service introduction documents.
  • Coordinating with multiple teams from around the program, and with client and external organizations.
  • Designed and developed Complex Mappings, Reusable transformations, Mapplets, Stored Procedures, Source Qualifier, Unconnected and Connected lookups, Router, Filter, Normalizer, Expression, Aggregator, Joiner, Update Strategy, XML Parser/Generator and more.
  • Automated the Data Reconciliation process using Informatica ETLs to ‘Tie’ the data, specifically dollar amounts between source and target after the Load.
  • ER Model and DB objects creation.
  • Communicating project risks, issues, time lines, solutions, and status to the leadership.
  • Preparing the ETL Technical design/ ETL mapping specification documents for all the data marts.
  • Design/Build/Unit Testing of ETL/ESPs.
  • Preparing new joiners to gain to the client speed by constantly tutoring them and giving knowledge sharing sessions.
  • Performed production support activities.

Confidential

Senior ETL Developer

Responsibilities:

  • Involved in Detail design and preparation of the ETL Technical design documents.
  • Develop Cast Iron Orchestrations.
  • Design, Build, Unit test.
  • Participate in Code review of the peers.
  • Analyzing new change requests/enhancements.
  • Prepared SIT test scripts and execute SIT.
  • Defect Fixing and continuous Tracking of defects
  • Provide UAT Support.
  • Provide status on ongoing activities in client team calls, discuss road blocks, progress on a daily basis and discussing team concerns and management.

Confidential

ETL Developer/ Module Lead

Responsibilities:

  • Involved from PL101 phase with functional architects for initiatives and finalizing the System requirements.
  • Coordinating with the onshore team, understanding the business requirements and preparing the technical specification document using the function specification document provided by the Client team.
  • Detail design, Build, unit testing, peer review.
  • Supporting operations team on production issues, Impact analysis and design solution approach for Production Defects.
  • Creating Production deployment plans and taking part in production deployment.
  • Extensively worked in developing ETLs with variety of transformations, implementation techniques like SCD1, SCD2, SCD3, SCD4.
  • Supervised a team of 3 associates.

We'd love your feedback!