We provide IT Staff Augmentation Services!

Sr Etl Developer Resume

Norfolk, VA

SUMMARY

  • Over 7+ Years of experience in Information Systems with strong background in SDLC, Data Warehousing and Database Development. Experience in ETL using Informatica Power Center 10.x/9.x/8.x.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
  • Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manager).
  • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
  • Strong understanding of OLAP and OLTP Concepts.
  • Extensively worked on Informatica Designer Components - Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer.
  • Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
  • Expertise in developing Slowly Changing Dimensions mappings(Type1, Type2) and Change Data capture
  • Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, cursors, and Indexes with Query optimizations as part of ETL Development process.
  • Expertise in different Informatica Performance Tuning issues like Source, Target, Mapping, Transformation, session to make them more efficient in terms of session performance.
  • Used Workflow manager to create and configure workflow and session task to load data.
  • Created tasks, sessions etc. in the workflow manager and monitored them in the workflow monitor.
  • Worked with Pmcmd to interact with InformaticaServer from command mode and execute the Shell scripts.
  • Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informaticadebugger to identify issues in mapping execution
  • Extensively worked on Relational Databases RDBMS like Oracle 10g, MS SQL Server. Also worked on various Source files like flat files, XML files, and CSV files.
  • Experience in SQL, PL/SQL and UNIX shell scripting.
  • Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
  • Created and wrote shell scripts (Bash), Python and PowerShell for automating tasks.
  • Quick learner with ability to master new concepts and applications.
  • Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycl

TECHNICAL SKILLS

Operating System: Windows 10/Windows 7/ XP/ NT/95/98/2000, UNIX, and LINUX

Database: Oracle 12C, MSSQL 2016/2012/2008 , DB2,Postgre SQL.

Database Tools: TOAD 12.10, SQL *Loader, TOAD data point .

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, C, C++, XML, HTML, VBscript, Python.

ETL Tools: Informatica 10.x/9.x/8.x(Power Center), Power Exchange, SSIS, Axway Mapping services

PROFESSIONAL EXPERIENCE

Confidential, Norfolk VA

SR ETL developer

Responsibilities:

  • Interacted actively with Business Analysts on the Design process for various Sources and Targets.
  • Worked in AGILE SCRUM environment regularly attending the Status Meetings and updating status to Scrum Master and involved in Code Review meetings, Implementing User Stories etc.
  • Developed rules and mapplets that are commonly used in different mappings.
  • Used various transformations like Look up, SQL, joiner, filter, Router to develop the mappings.
  • Created complex mappings in Powercenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
  • Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
  • Implemented SCD1, SCD2 type mappings to capture new changes and to maintain the historic data.
  • Worked on extract and load type of mappings.
  • Worked on SQL, Oracle databases.
  • Designed Work Flows that uses multiple sessions and command line objects (which are used to run the VB scripts).
  • Created email notifications using email tasks to notify the user for file load status.
  • Created email task to send file attachments.
  • Involved in creating stored procedures and using them inInformatica.
  • Responsible for Performance Tuning at the Mapping Level and Session level.
  • Used Debugger to troubleshoot the mappings.
  • Worked extensively on Unit Testing the ETL mappings and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.
  • Responsible for migration of the work from DEV environment to testing environment.
  • Responsible for solving the testing issues.
  • Created documents that have the detailed explanation of the mappings, test cases and the expected results and the actual results.
  • Create Cursors using T-SQL.
  • Created SSIS packages to generate the excel reports.
  • Created EDI files using axway mapping services using the flat file as the source.
  • Involved in loading the partner flat files into the SQL database.
  • Crated VBscripts to validate the vendor inbound files and move the files from inbound to outbound location.
  • Created mappings to validate the XML and CSV files and loaded into facets.
  • Loaded all the claim information from FACETS to the transactional database.
  • Created mappings to generate xml and CSV files to notify the vendor about the claim status.
  • Developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
  • Provided Production Support.

Environment: Informaticapower center 10.4,Informaticapower center 10.2, Informaticapower center 9.5.1, PostgreSQL, Dbeaver, SQL Server 2012/2016, PL/SQL, Windows 10, SQL Developer2012, SDLC Jira, SVN Tortoise, Tidal, ControlM, VBscript, Toad Data Point, Axway Mapping Services, Python.

Hire Now