We provide IT Staff Augmentation Services!

Etl Lead Resume

VirginiA

PROFESSIONAL SUMMARY:

  • Having 12 years of IT experience that span across in Health care, Banking, Financial and Retail, domains. In depth knowledge about various phases of IT projects which include analysis and planning, building user stories/ gathering business requirements, development, testing, data modeling, data governance and implementation encompassing both AGILE and Waterfall methodologies.
  • Expertise in Data Warehousing, Data Migration, Data Integration, Data Analysis and Data Conversions using ETL tools - INFORMATICA Cloud Service (ICS) & INFORMATICA Powercenter.
  • Expertise in Data Synchronization/Replication/Masking tasks across On-Premise and SaaS Applications.
  • Experience with Web Services calls based APIs, ReST.
  • Developed Process Orchestration in SFDC using Informatica Cloud Real time.
  • Strong knowledge on INFORMATICA Cloud and Real-Time Integration.
  • Expert in development using INFORMATICA Client Tools - Source Analyzer, Designer, Mapplet Designer, Repository Manager and workflow Manager.
  • Experience in design and development of complex mappings, Reusable Objects (Mapplets, Lookups, Transformations, Tasks and Sessions), transformations, extraction and loads.
  • Experience in loading data, troubleshooting, Debugging mappings, performance tuning on components (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of performance.
  • Worked with heterogeneous source systems ranging from legacy systems, SALESFORCE, Databases like TERADATAv13, Oracle, Amazon Redshift, SQL server, XML, DB2 and flat files.
  • Expert level development skills on file transfer utilities like NDM, FTP & SFTP.
  • Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.
  • Proficient in Unix scripting & Shell programs.
  • Experience in developing reports using Business Objects (BO).
  • Hands on experience on handling huge volume of data and performance tuning.
  • Successfully worked in global delivery models - with offshore & onsite teams
  • Widely used JIRA Dashboard to track the issues and communication with the teams.
  • Also have experience in Mainframe technology- JCL, COBOL, VSAM, DB2 and CICS.

TECHNICAL SKILLS:

Data warehousing Tool: INFORMATICA cloud(IICS & ICRT), INFORMATICA POWERCENTER 9.x/10.1

Database: Teradatav13, ORACLE 9i/10g/11g, Amazon Redshift, Vertica 6.1, MS SQL server 11, DB2 & IMS

SaaS App: SFDC & AWS

Scripting Language: SQL, Unix Scripting, Bteq, Fast load & Multiload

Data Modelling: CA Erwin

Reporting tool: Business Objects XL R3

Scheduling Tools: Control-M(CTM),WLM, ESP & CA-7

Others: POSTMAN, JIRA, SNOW, HPSM, MS Office suite including MS Visio, APM

MAINFRAME: COBOL, JCL, CICS, VSAM, CHANGEMAN, ENDEVOUR, FILE-MANAGER, File-Aid, SPUFI.

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

ETL Lead

Responsibilities:

  • Worked closely with Business analysts and Data architects to understand and analyze the user requirements.
  • Involved in building the ETL architecture for Data Migration.
  • Worked on Data integration between SALESFORCE and Teradata using INFORMATICA Cloud (ICS).
  • Developed Cloud Mappings and Data integration processing Cloud services.
  • Developed complex mappings and implemented SCD Type-II and Type III transformation logics to load the data from various sources.
  • Implemented data manipulations using various Transformations like Aggregate, Filter, Normalizer, Sequence Generator, Expression etc.
  • Wrote BTEQ scripts to transform data.
  • Used Teradata utilities fastload, multiload, tpump to load data.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
  • Extensively used Change data capture concept in INFORMATICA to capture the instream data flow changes.
  • Working on Dimension & Fact tables, developed mappings and loaded data on to the relational database.
  • Developed logical and physical data models that capture current/future state data elements.
  • Generated UNIX scripts for automatic daily load processes.
  • Generated completion messages and status reports using workflow manager.
  • Involved in preparing ETL specifications and unit test plans for the mappings.
  • Extensively worked in the performance tuning of the ETL process.
  • Successfully migrated the mappings to TEST and production environment.

Tools: INFORMATICA Power center 9.x/10.1, INFORMATICA Cloud, Teradata v13, MS SQL serverDB2/IMS, UNIX, JIRA, Business Object, Control-M(CTM)

Confidential, PA

Senior ETL Developer

Responsibilities:

  • Worked on Data Synchronization/ Replication and Masking Tasks using Informatica Cloud.
  • Developed Cloud mappings to extract data from different Sources.
  • Enhance mappings for any changes/additions to Business/Source Attributes.
  • Developer Process Orchestration in SF using Cloud Real-Time.
  • Used API and ReST API calls.
  • Worked on Amazon Redhift for Data integration with Salesforce.
  • Worked on the SFDC outbound Messaging triggers to implement the real time update between SaaS and On-premise applications.
  • Implemented Change Data Capture using Cloud Mappings.
  • Automated the cloud jobs to run daily with email notification for any failures.

Tools: INFORMATICA Cloud, INFORMATICA Power center 9.x, Salesforce, Teradata v13, Amazon Redshift, UNIX

Confidential, PA

Senior ETL Developer

Responsibilities:

  • Analyzed functional specifications provided by the architect and created technical specifications document.
  • Ensured architectural adherence through blueprint and design reviews.
  • Designed and implemented the complex project with high quality.
  • Developed logical and physical data models, DB2 look alike physical model structures that capture incremental and history data.
  • Performed data manipulations using various Informatica Transformations like Joiner, Sorter, Router, Filter, Expression, Aggregator, Union, Transaction Control, Update Strategy & Look Up.
  • Extensively used Change data capture concept in Informatica to capture the changes in the datawarehouse.
  • Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
  • Support of bug fixes and data issues reported.
  • Designed data feeds to load Teradata tables from flat files, using BTEQ scripts.
  • Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
  • Applied different optimization techniques to enhance performance at various levels which includes SQL tweaking, Sourer, Target and transformation level optimization.
  • Extended support for SIT & UAT
  • As part of release management, participated in migration of the components till PROD from development environment.
  • Logical and Physical data model build using ERWIN.
  • Created WLM/CTM jobs to automate run and designed required recovery/ad-hoc components.

Tools: INFORMATICA Power center 9.6, Oracle 10g, UNIX, SQL developer, WLM

Confidential, TX

Senior System Developer

Responsibilities:

  • Worked closely with business team to finalize on the validation rules that need to be applied outside Informatica ETLs.
  • Participated in meetings with business analysts to understand the user requirements and assisted in the design of BRS.
  • Created technical specification document for each workflow in exhaustive detail listing all technical and business validation rules, look-up tables and error messages.
  • Reviewed the design with project tech lead and test team.
  • Using Informatica Power Center Designer, designed Mappings.
  • Created Mappings with Transformations, Sessions and Workflows.
  • Created various transformations such as Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
  • Created and used reusable transformations when required.
  • Extensively used mapping parameters, mapping variables and parameter files.
  • Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping
  • Logged the errors during execution in Error tables.
  • Created backup tables to store the history of all the transactions performed on the given data.
  • Worked with Informatica administration and integration teams to migrate code to higher environments without any glitches
  • Created guides and run books for production support team

Tools: INFORMATICA power center 8.6, ORACLE 8i, DB2, ERWIN, Unix shell scripting.

Confidential

System Developer

Responsibilities:

  • Ensured architectural adherence through blueprint and design reviews.
  • Analyzed existing system and prepared and presented Impact Analysis.
  • Support of bug fixes and data issues reported.
  • Experienced in Requirement Gathering, Analysis, Design and Development.
  • Write High level and Technical design documents.
  • Developed new batch and online functionalities using COBOL, DB2, CICS, VSAM and JCL
  • Developed Online Screen using Basic Mapping Support(BMS) macros.
  • Develops test plans to verify logic of new or modified programs. Identifies issues as appropriate
  • Assists in resolving production support problems. Develops and suggests alternative approaches to resolving problems.
  • Understanding the business process and updating SAD (System Appreciation
  • Documents)
  • Worked on project under SOA architecture.
  • Involved in user reported Issues - Root cause analysis & its fix
  • Managing MF batch jobs & Online transactions
  • Fixing Job failures/Transaction abend - Data Issues & Problem Management
  • Reviews and attend client meetings.
  • Quality assurance by defect tracking.
  • Ownership of the checklists.
  • Project Co-ordination with various application teams involved

Tools: Cobol, JCL, CICS, DB2, IMS, File Manager, File-Aid, Fault Analyzer, SPUFI, CA -7, Endevor

Hire Now