We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Herndon, VA

PROFESSIONAL SUMMARY

  • 7 Years of strong experience in Information Technology Industry in Analysis, Design, Development, Testing and Maintenance of various data warehouse projects in Industry verticals such as BFS (Banking & Financial Services), Healthcare and Retail Industry.
  • 7 Years of strong experience in Development, Testing, Maintenance and Support of ETL (Extraction, Transform and Load) using Informatica Power Center 9.5.1/8.1.6/7.1.4/6.1 Versions.
  • An Expert in Informatica Power Center tool which includes components like Power Center Designer, Workflow Manager, Workflow Monitor & Repository manager. Extensively worked on ETL Informatica Transformations effectively including - Source Qualifier, Application Source Qualifier, Connected - Unconnected Lookup, Filter, Joiner, Expression, Normalizer, Stored procedure, Rank, Sequence Generator, Union, Sorter, Router, Mapplets, Reusable Transformations and Worklets.
  • In-depth Knowledge of software QA methodologies and Waterfall, V-model, Agile and Scrum.
  • Expertise in tuning and optimizing the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
  • Experience in Informatica Administration: Creating deployment groups, Users, Folders and optimizing Informatica Server settings for optimal performance.
  • Proficient in Unix Shell Scripting and ETL process automation using Autosys Scheduler and TIDAL Scheduler.
  • Implemented CDC (Change Data Capture), slowly changing Dimension methodologies for real time data warehousing environments.
  • Implemented IDQ Address standardization mapplets to standardize validate and format client’s addresses for marketing purposes.
  • Very strong in Relational Databases (RDBMS), Data Modeling and Design and build Data Warehouse, Data Marts using Star Schema and Snow Flake Schema for Faster and effective Querying.
  • Experience in writing & execution of Test Cases, developing and maintaining Test Scripts, Run Books according to the business specification and Defect management.
  • Proficient in gathering business requirements and converting them into functional, technical specifications and developed mapping documents to map source systems to the data warehouse model.
  • Experience working with databases like Oracle 11G/ Netezza 6/ SQL Server 2008/ IBM DB2/ POSTGRESS.
  • Experience providing On Call Production support to all the Enterprise Data Warehouse ETL Schedules. Experience resolving in ongoing maintenance issues and Work orders.
  • Ability to understand the available technology, tools and existing designs, and work on complex problems.
  • Excellent problem solving with good Interpersonal skills, Quick learner and adaptive to new, challenging technical environments and versatile team player with ability to work independently as well with team members.

TECHNICAL EXPERTISE

Data Warehousing: Informatica Power Center 9.5.1/8.1.6/7.1.4/6.1

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Schema Modeling, Relational Modeling, Physical and Logical Modeling.

Databases: Oracle 11g/10g/9i/8i/7.3, MS SQL Server 2000/2003/2005/2008, Netezza, IBM Db2, MySQL

Tools: MS Office, TOAD, Secure CRT, PL/SQL Developer, WinSQL, Putty, WinSCP, TortoiseSVN

Operating Systems: Windows 9x/NT/2000/XP, UNIX (AIX)Schedulers Tidal, Control-M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Senior ETL Developer

Responsibilites:

  • Worked on Data Acquisition, Data Induction, Data Transformation and Data Validation for Fannie Mae Loan Accounting Initiative Legacy Systems.
  • Worked on ETL - Informatica/Unix portion of the Loan Accounting Initiative Project dat Performs Technical Validation, Business Data Validation for the Incoming (Inbound Processor) and Outgoing (Outbound Processor) accounting data into and from LAI systems.
  • Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts (SME).
  • Wrote and reviewed documents like Functional Specifications (FS), Solution Specifications (LAI - SSD), ETL Specifications.
  • Work in the agile environment with frequently changing requirements and participated in daily Scrum meetings and daily status calls.
  • Involved in creation of Informatica mappings to build complex business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Connected and Unconnected Lookups, Filter, Router, Rank, Mapplet Input, Mapplet output, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
  • Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
  • Extensively worked on Mapplets, Reusable Transformations, and Worklets there by providing the flexibility to developers in next increments.
  • Extensively worked on UNIX shell scripts to handle pre and post session tasks and used Unix CHECKSUM Property during Technical and Business Data Validation.
  • Creation of sessions and workflows according to the data load in to different systems.
  • Created the Autosys JOB Creation documents and send them to Command Center (CC) team to schedule Informatica Jobs and Unix Scripts accordingly.
  • Extensively worked on Performance tuning of targets, sources, mappings and sessions.
  • Worked on creation of Oracle Tables, Views, Materialized Views and Synonyms.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Extensively worked on Informatica Code Migration processes across the DEV/QAE and PROD environments by maintaining Version Control (Check In/Check Out) using TortoiseSVN tool.
  • Implemented the Error Records Handling mechanism Using Event Processing tables.
  • Involved in different phases of testing like Unit, Functional, Integration and System testing.
  • Implemented SCD Type 1 and SCD Type 2 methodologies in ODS tables loading, to keep historical data in data warehouse.
  • Creation of Review documents for specification document and test cases.
  • Troubleshoot loading failure cases, including database problems.
  • Prepared documents like Deployment Doc, Estimation Reports, Run Book Doc, Tractability Reports, Development tracking report and weekly status reports (WSR).
  • Involved in scheduling the jobs in Autosys using UNIX scripts.

Environment: Informatica Power Center v9.5.1, Oracle 11g/10g, Autosys Scheduler, Windows-XP (Client), Informatica servers on Unix (Solaris), WinSCP, Putty, TortoiseSVN, TOAD.

Confidential, Columbia, MD

Senior ETL Developer

Responsibilities:

  • Analysis of requirements and finding the gap between use cases, User interface documents and ETL specifications.
  • Creation of ETL Design documents with the halp of use cases and User Interface documents, Business rule documentation and PDM.
  • Creation of mappings according to the use cases by following the ETL specifications.
  • Creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Joiner, Union, Aggregator, Sorter, Sequence generator, Router, Update Strategy, and Stored procedure.etc.
  • Extracted data from of different types of Flat files, Oracle.
  • Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
  • Created and tested Power Exchange Data maps for Oracle CDC capture.
  • Involved in identifying the Power Exchange Oracle CDC limitations and supplementary solutions.
  • Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications. .
  • Involved in Unit, Functional, Integration and System testing and preparation review documents for the same.
  • Involved in scheduling the jobs in Control M using UNIX scripts and even developed PL/SQL stored procedures.
  • Involved in loading all Batch Scheduling tables with the halp of UNIX script.
  • Maintained all the documents in the clear case and CVS for Version control.
  • Created User defined functions (UDF) to reuse the logic in different mappings.
  • Created and tested shell scripts to automate Job scheduling by using commands like pmcmd.
  • Data investigation in the analysis of incoming data from the various source systems, documenting the data anomalies and generating Data Quality reports.
  • Code migration from development to QA and production environments.
  • Developed and tested stored procedures, functions and packages in PL/SQL.
  • Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer and PL/SQL Developer.

Environment: Informatica PowerCenter v9.0.1, Oracle 10g/9i, Tidal Schedular,Windows-XP (Client), Informatica servers on Unix (Solaris), Netezza, PL/SQL Developer.

Confidential, Collegeville, PA

ETL /Informatica Developer

Responsibilities:

  • Understood existing business and customer requirements.
  • Involved in designing the mappings between sources and targets and also tuned them for better performance.
  • Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Router and Update Strategy.
  • Code migration from development to QA and production environments.
  • Extracted data from of different types of Flat files, Relational Databases Oracle.
  • Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
  • Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse.
  • Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications.
  • Involved in Unit testing and System testing and prepared Test plan documents
  • Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
  • Creation of sessions and workflows according to the data load in to different systems.
  • Maintained Coding standards and participated in Code Review.
  • Involved in Performance tuning of mapping level and session level.
  • Involved in Load schedule plan.
  • Creation of sessions and workflows according to the data load in to different systems.
  • Maintained Coding standards and participated in Code Review.
  • Involved in Performance tuning of mapping level and session level.
  • Involved in scheduling the jobs in Control M using UNIX scripts and even developed PL/SQL stored procedures.

Environment: Informatica Power center 8.1.6, Oracle 10g, Teradata, Clear case, MS Office, DB2, UNIX - AIX 5, Windows XP.

Confidential, NJ

ETL / Informatica Developer

Responsibilities:

  • Understood existing business and customer requirements.
  • Involved in designing the mappings between sources and targets and also tuned them for better performance.
  • Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Router and Update Strategy.
  • Code migration from development to QA and production environments.
  • Extracted data from of different types of Flat files, Relational Databases Oracle.
  • Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
  • Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse.
  • Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications.
  • Involved in Unit testing and System testing and prepared Test plan documents
  • Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
  • Creation of sessions and workflows according to the data load in to different systems.
  • Maintained Coding standards and participated in Code Review.
  • Involved in Performance tuning of mapping level and session level.

Environment: Informatica Power Center 7.1.4, Windows XP, UNIX, Oracle 8i.

Confidential

Informatica Developer

Responsibilities:

  • Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
  • Prepared technical documentation, design transformations dat are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution
  • Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing.
  • Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
  • Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters.
  • Used the Workflow Manager to create Workflows, Worklets and Tasks.
  • Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing.
  • Used design and development techniques dat resulted in efficient, maintainable, and high quality ETL processes.
  • Used problem solving skills and quickly understood relationships between data with little documentation or guidance.

Environment: Informatica Power Center v6.1, PowerMart 6.2, Oracle 7i, PL/SQL, Toad 7.6, Windows, UNIX.

Hire Now