We provide IT Staff Augmentation Services!

Sr Etl Developer Resume

Dunmore, PA

SUMMARY

  • 7 years of total IT experience in Data Warehousing and Business Intelligence working in various BIDW projects (Healthcare, Insurance domain).
  • Worked in all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing.
  • With strong skillset in ETL development, testing and production support in Data Warehousing.
  • Strong knowledge in implementing Change Data Capture (CDC) and Slowly Changing Dimensions (SCD’s) 1, 2, and 3.
  • Good exposure to SDLC process viz. Requirements Analysis, Design, Development, Change Management and testing.
  • Strong Experience in Informatica Power center versions 10.x,9.x (Designer, Workflow manager, Workflow monitor and Repository manager)
  • Expertise in data warehouse ETL strategies, design and development for staging, fact / dimension and summary tables load including integration with various source/targets like Oracle, Teradata and Flat Files
  • Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter.
  • Strong skills in coding and debugging Teradata utilities like Fast Load, MultiLoad and Fast Export for Teradata ETL processing huge volumes of data throughput.
  • Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x
  • Expertise in UNIX shell scripting and UNIX environment using standard commands
  • Experience of working with Teradata and its utilities (Fast export, mload) used in Informatica
  • Have experience in working with ORACLE 11g/10g, SQL Server 2012/2014, Teradata 16/14 databases.
  • Created Mappings and Transformation logic for data loads into EDW/dimensional models.
  • Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts to run various batch jobs.
  • Worked extensively in design and analysis of Requirements, Development, testing and deployment.
  • Prepared various types of documents like ETL specification, Data Mapping, Test cases, Test Results etc.
  • Worked closely with Testing team to assist in Integration, System and User
  • Acceptance Test (UAT) scenarios.
  • Hands on experience in performance tuning and extensive experience in debugging and identifying the issues.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x / 9.x, Informatica IICS

Data Warehouse: Dimensional model - STAR Schema, Fact/Dimension tables, SCD 1,2,3

Databases: Oracle 19c, Teradata 16, SQL Server

Operating Systems: Windows, Unix, Linux

DB and other Tools: SQL Developer, Teradata SQL Assistant, Toad

Programing: C/C++, SQL, PL-SQL Unix scripting

Scheduling: Control-m, Informatica Scheduler

Others: Quest, TOAD, SQL*PLUS, SQL*Loader, WinSCP, Putty, Jira

PROFESSIONAL EXPERIENCE

SR ETL DEVELOPER

Confidential, Dunmore, PA

Responsibilities:

  • Analyzed the business requirement and functional specifications.
  • Created mappings to implement technical enhancements for data warehouse by extracting data from sources like oracle and delimited flat files.
  • Development of ETL using Informatica 8.6.
  • Applied slowly changing dimensions like Type1 effectively to handle delta loads.
  • Prepared various mappings to load the data into different target tables.
  • Used various transformations like SQ, Aggregator, Joiner, Filter, Lookup, and Update Strategy for designing and optimizing the mapping.
  • Created sessions and workflows using the workflow manager.
  • Used fastload and fastexport utilities in Teradata at different stages in the project.
  • Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
  • Prepared SQL queries to validate the data both in source and target database.
  • Created and executed unit test cases for the mappings developed.
  • Closely worked with reporting team to ensure correct data is presented in the reports

ETL DEVELOPER

Confidential, Hartford, CT

Responsibilities:

  • Actively involved in interacting with business users to record user requirements and Business Analysis.
  • Documented Data Mappings/ Transformations as per the business requirement.
  • Prepared Technical Design documents and Test cases.
  • Creating and maintaining source-target mapping documents for ETL development team.
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse tables.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
  • Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
  • Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of database
  • Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Wrote hundreds of SQL query for data analysis to validate the input data against business rules.
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
  • Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
  • Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
  • Improved performance testing in Mapping and the session level.
  • Worked with UNIX shell scripts for job execution and automation.
  • Coordinated with Autosys team to run Informatica jobs for loading historical data in production.

ETL DEVELOPER

Confidential, Irving TX

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer.
  • Developed mapping parameters and variables to support SQL override.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Hire Now