We provide IT Staff Augmentation Services!

Etl/interfaces Lead Resume

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 CDC, 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 an Integration/ETL development lead participating in Planning and Analysis with Client team, Solution Architects. Fit/ Gap Analysis.
  • Data modeling, ER Designs, Database object modifications.
  • Leading the co - ordination between Clients, External Vendors, Environment Team, DBA, Application Support for the Development Team, and reporting the project status to Senior Project leadership.
  • Finalizing technical component inventory for 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 CDC 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 Mock, QA and production deployment.

TECHNICAL SKILLS:

  • Informatica 9.6.1 Power center, Power exchange (CDC),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

ETL/Interfaces Lead

Responsibilities:

  • As an Integration/ETL development lead participating in Planning and Analysis with Client team, Solution Architects. Fit/ Gap Analysis.
  • Data modeling, ER Designs
  • Leading the co -ordination between Clients, External Vendors, Development Team, Environment Team, DBA, Application Support and reporting the project 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.
  • 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

ETL/Interfaces Lead

Responsibilities:

  • As an Integration/ETL development lead participating in Planning and Analysis with Client team, Solution Architects. Fit/ Gap Analysis.
  • Data modeling, ER Designs
  • Leading the co -ordination between Clients, External Vendors, Development Team, Environment Team, DBA, Application Support and reporting the project 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, 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.
  • 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

ETL/Interfaces Lead

Responsibilities:

  • 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.
  • Played role as an Interfaces Lead 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.
  • 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

ETL/Interfaces Lead

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.

Hire Now