We provide IT Staff Augmentation Services!

Etl Lead Resume

2.00/5 (Submit Your Rating)

New, JerseY

SUMMARY:

  • 14 years of IT experience with strong technical skills focus on Data warehousing and business intelligence using ETL Tool - Informaitca PowerCenter, Informatica Data Quality and Master Data Management, Oracle, Teradata, Redshift and Unix shell scripting with key emphasis on requirement gathering, data analysis, design and architect ETL solution and coved all the projecct phases.
  • Experience in design and architecting end to end ETL solutions. Have good hands on exposure (till date) in working with Informatica components like mappings, mapplets, sessions, workflows, reusable components, tasks, debugger, and troubleshooting on mapping failures also have good exposure in tuning the ETL for better performance with high data volumes
  • Strong expertise on data warehouse architect including data modeling skills with experience in relational modeling theory and star & snow flake schemas.
  • Extensive experience in Informatica upgrade from 7.1 to 9.6. data profiling. Have good understanding on IDQ validations and MDM techniques with the match and merge techniques with the rules and configuration for the survivor / golden record.
  • Proficient in Logical data model, Physical data model, Data warehouse concepts, Dimensional Modeling using star schema and snow flake schema. Having experience in handling SQL, PL/SQL, packages, procedures, functions and triggers, tables, views, indexes, constraints, synonyms. Have good hands on project exposure in data migration from Oracle8 to Teradata13.1 and also from Netezza to Redshift
  • Hands on Unix shell script experience, for handling the ETL loads, file handlings and automation process. Have good exposure in scheduling tools like Autosys, Informatica scheduler, Tidal, Opcon
  • Have good exposure in interacting with business users, business analysts in analyzing business requirements and translating requirements into functional and technical design specifications. Experience in writing high level and detail design documents, mapping documents based on business requirements
  • Experience in Informatica enterprise platform setup - server installation, configuration and Administration of Informatica Power center client/server. Have created/managed users, user groups, folders and upgrades
  • Handled code migration / deployment activities, QA related activities and have very good understanding of quality assurance policies & procedures. Involved in conducting technical on ETL process, DW concepts, and Informatica tool
  • Good team player with excellent inter-personal skills and customer interaction capabilities. A quick learner and mentor with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations
  • Experience in handling the team at onsite and offshore with Onsite-Offshore model. Providing technical and managerial oversight of all application development projects: develop concepts and strategies; define scope, procedures and objectives; and coordinate cross-functional technical team resource. Involved in project plans and estimation and responsible for project tracking and deliverables and periodic customer status reporting
  • Ability to work independently, with strong analytical and technical skills, with good communication, good team building, management skills

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10/9.X/8.X, Informatica Data Quality, Kalido

Database Systems: Oracle 9i/10g/11g sql, pl/sql, Teradata, Redshift, SQL Server

Languages: Unix shell scripting

Operating Systems: Windows, Unix

Scheduling Tools: Autosys, Tidal, Opcon, Informatica scheduler

Version Control: Bitbucket, Tortoise

Other Tools: Toad, SQL Developer, Oracle Forms and Reports, Putty, Visio, Erwin 3.x/4.x, Mercury Quality Center, service now, Jira

PROFESSIONAL EXPERIENCE:

ETL Lead

Confidential, New Jersey

Environment: & Tools: Informatica PowerCenter 9.6 and 10.2, Flat files, Oracle SQL, PL/SQL, SQL Server, Unix Scripting, Autosys, Jit Bash, ITSM, Jira

Responsibilities:

  • To upgrade the current ETL platform from Informatica 9.6 to 10.2 on the new linux host
  • Co-ordination with all upstream and downstream application for the ssh public key setup and test the connectivity from the remote host to the new server. Handled the ciphers during the sftp
  • Co-ordination b/w Infa admins and system admins to tackle the challenges during the engagement
  • Migrate and identify the issues and to come up with the solution and to address the failures
  • Handling the necessary file systems path changes in all the shell scripts, to address the path hardcodes issues in scripts and Informatica to accommodate into the ETL platform architecture
  • Testing the drivers on new machine, DB connectivity, http, Java, JSON files downloads that are used in the application
  • Autosys Jil changes - with respect to the new linux server, Profile, command calls
  • Prepared many one script to address the issues as part of the server upgrade
  • Informatica password variable handling during the pmcmd command
  • Profile file path changes in the script and files and handled the path hardcodes to fit into the platform
  • Mail command changes
  • SFTP command changes
  • End of line character (EOS) issues on the white spaces
  • Autosys Jil updates - download, Replace the jil and upload the revised jil

Confidential, New Jersey

ETL Lead, Design and Architect

Environment: & Tools: Informatica PowerCenter 9.6 and 10.2, Flat files, Oracle SQL, PL/SQL, SQL Server, Unix Scripting, Putty, Autosys, Jit Bash, ITSM, Jira

Responsibilities:

  • Requirement gathering from business, IT and other vendors, Co-ordination with other project stakeholders, and cross team with queries, request, data deviations. Analyzing the gaps on the ETL process and to come up recommendation approach and implementation plan
  • Handling ETL and DB design, data analysis, data modelling and impact analysis, identify the data usage for statistical decision and Document and maintain the process and flow on the confluence page
  • Architect the framework - data quality / data validations, audits, data age and size monitoring. Handled long running ETL’s to improve performance, Data profiling, gap assessment and implementing best practices
  • Handling informatica repository upgrade from 9.6 (1 node) to 10.2(3 nodes), script level changes, AutoSys changes, and to setup the environment up and running
  • Handling task tracker, code reviews, assigning tasks to team, manage and owns the deliverables. Data validation and data profiling, reviews and quality checks for the deliverable. Assisting team on the ETL and DB design solutions and addressing the technical challenges
  • Assisting clients, business and other internal teams on the process, data / information as needed.

Confidential, Miami, FL

ETL Lead / Designer

Environment: & Tools: Informatica PowerCenter, Informatica Data Quality, Flat files, Oracle SQL, PL/SQLSQL Server, Unix Scripting, Putty, Opcon, Service now, Platinum

Responsibilities:

  • Worked with business and IT team to understand business requirements in order to transform business requirements into effective technology solutions
  • Worked closely with Data Modelers to understand the data architecture with the functional requirements
  • Handled the ETL and DB design for the project requirements. Assisting the internal team on the technical challenges and solutions aspects
  • Worked closely with IDQ and MDM development team to validate, matching the address and define the quality standards and de-dupe the customer profile information from various sources with the trusted golden copy record for the warehouse consumption
  • Created High level, low level design documents, ETL specification documents, test cases document and traceability metrics
  • Developed and enhanced Informatica mappings, sessions and workflows, created reusable objects like Mapplets, Oracle SQL/PLSQL code, Unix Scripting, Opcon Jobs based on the business needs
  • Created Unix shell scripting for the file handling and Opcon scheduling
  • Created Triggers, PL/SQL code, opcon Jobs for the project requirements
  • Handled data analysis on the user queries on the day to day basis and handling the fixes on History and Incremental data and ETL code, task tracker, code reviews, onsite/offshore, handling overall deliverables.
  • Created deployment groups, rollout plan documents for production migration (mappings, workflows, parameter files and Unix scripts) and supporting the post production support during warranty
  • Handling the Code review request for the entire CCL with the Confidential platinum tool

Confidential, NY

ETL Lead / Designer

Environment: & Tools: Informatica PowerCenter 9.6.1, Redshift 1.0.1369, Oracle 11, Linux3.4.2Redwood, SAP, MicroStrategy, Control-M, Autosys

Responsibilities:

  • Responsible for requirement gathering from Confidential business and IT team, analysis of existing system and the new system, estimation, design, project tracking, offshore co-ordination and handling deliverables and code migration activity to QA, UAT and Production
  • Defining and finalizing the solution design for data loading, data reconciliation, error handling, Dashboard and reports
  • Convert business requirements into technical design document and designing and developing ETL mappings according to the business needs
  • Responsible for the project deliverables during all the phase of the migration activity and to report the daily status and progress to the Novo and Confidential management
  • Have a good hands on roles in the areas like technical ETL lead, design, ETL Development, data validation, data reconciliation and data profiling, reviews and quality checks for the deliverables
  • Responsible for identifying the root cause and gap analysis on the Production issues and to provide the fix. Defining data profiling strategy to provide data quality feedback to the data source owners
  • Responsible to prepare and maintain the documents like, project design, project estimation, tracking clarification logs, handling project status reports
  • Involved in migration activity from Netezza to Redshift. Handled the data fixes
  • Responsible to study and analyst the impact on existing FG system and to plug in the required NFG components.

Confidential, New Jersey

ETL Lead & Architect

Environment: & tools: Informatica PowerCenter, IDQ, MDM, Business glossary, Oracle, OBI, LinuxInformatica scheduler.

Responsibilities:

  • Requirement gathering from business, IT and other vendors, co-ordination with other project stakeholders, reporting team, and team
  • Handling ETL and DB design and design reviews, data analysis, data modelling and impact analysis, identify the data usage for statistical decision. Handled CDC using power exchange to capture and process the delta loads.
  • Document and maintain the process and flow on the project share point
  • Analyzing the gaps on the ETL process and to come up recommendation approach and implementation plan
  • Defining and finalizing the solution design for data loading, data reconciliation, error handling, Dashboard and reports
  • Convert business requirements into technical design document and designing and developing ETL mappings according to the business needs
  • Responsible for the project deliverable during all the phase of the migration activity and to report the daily status and progress to the Novo and Confidential management
  • Data validation and data profiling, reviews and quality checks for the deliverable
  • Responsible for identifying the root cause and gap analysis on the Production issues and to provide the fix. Defining data profiling strategy to provide data quality feedback to the data source owners
  • Responsible to prepare and maintain the documents like, process flow, project design, project estimation, tracking clarification logs, handling project status reports
  • Designed the enterprise level Informatica platform architecture at Novo and installed the Infa server setup and implemented at Novo, coordinated with different stake holders and guided the team
  • Handled the Infa Admin roles during the Enterprise level Informatica platform setup
  • Upgraded the existing silo Orion Infa repository 7.1 to 9.6 from windows to Linux platform, converted the batch scripts to Linux scripts

Confidential, Chicago

ETL Lead Developer

Environment: & tools: Informatica PowerCenter 9.5, Oracle 11g, Unix shell scripts, Tidal

Responsibilities:

  • Responsible for requirement gathering from Confidential Business and IT team, analysis of existing system and the new system, estimation, design, Project tracking, offshore co-ordination and handling deliverable and code migration activity to QA and Production
  • Responsible for the project deliverable during all the phase of the migration activity and to report the daily status and progress to the Confidential management
  • Performed data analysis and data validation between the existing SHA system and the IMS-FIA system for data accuracy
  • Handled the technical ETL design for the Claims data switch project and created the data base design for the IMS-FIA system. Investigation & fix problems raised by the MSBI report users and downstream users.
  • Perform quality checks on all end products with all quality metrics captured at all stages before publishing to the consumers
  • Created Informatica cloud jobs for read and load into Veeva
  • Production issue analysis and fix in the financial reporting system
  • Actively involved in preparing the documents like, project design, project estimation, tracking clarification logs, handling project status reports and PMO report. Best practices and defect tracking activities

Confidential, Chicago

ETL Lead Developer

Environment: & tools: Informatica PowerCenter 9.1, Oracle, Teradata, Unix shell scripts, Autosys

Responsibilities:

  • Involved in Estimation, Project tracking and assigning deliverable to offshore and QA related activities
  • Involved in technical design for the GIS EIMS&QSDW project and Designed and framed the EIMS ETL process control to track the ETL load status
  • Responsible for Requirement gathering, Design, Development, testing and Implement of customized applications. Does the ETL - Informatica, Oracle,Unix and Autosys framework for the GIS EIMS project
  • Perform quality checks on all end products with all quality metrics captured at all stages before publishing to the consumers
  • Actively involved in preparing the documents like, project estimation, best practices and defect tracking Activities
  • Guided team to identifying performance bottlenecks and tuned for better performance
  • Migrated the ETL code from Informatica 8.5 to 9.1, Autosys from 4.5 to R11 and Unix scripts to Linux scripts

Confidential, NY

ETL Lead Developer

Environment: & tools: Informatica PowerCenter, Oracle, DB2, Unix shell scripts, Autosys

Responsibilities:

  • Leading the development team and Provide technical guidance to the teams within the Factory. Involved in all the technical design
  • Involved in requirement gathering/analysis, Design, Development, Testing, Code review, Code release of Informatica mappings/mapplets/workflows/DB components/ Unix script/Autosys
  • Code development as per the requirement document used the loaders and relational connections like Fast Load, MultiLoad, FastExport and BTEQ SQL, based on the data volumes
  • Handled Created data profiling reports, data re-consolation
  • Taking care of L3 support as well in Production/Contingency environment
  • Handling the feed integration between the Confidential and Merrill Lynch
  • Ensure that all modules executed within the factory deliver with high quality components on-time and handling the overall quality process for the team
  • Ensure that all modules adhere to TCS and Client quality processes. Followed the Best Practices and Standards that are implemented / followed across projects within factory
  • Involved in bug fix/enhancement and review meeting

We'd love your feedback!