We provide IT Staff Augmentation Services!

Sr Etl Developer Resume

Denver, CO

SUMMARY:

  • Around 11 years of IT experience in Software Analysis, Design and Development for various software applications in client - server environment in providing Business Intelligence Solutions in Data Warehousing for Decision Support Systems, OLAP and OLTP Application Development and worked on the Database Application Development.
  • Sound Data Warehouse, Data mart, Data Integration and Data Conversion Projects ETL experience using Informatica Power Center 9.x/8.x/7.x
  • Proficient in all phases of the Software development lifecycle (SDLC).
  • Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center
  • Excellent experience on migrating the ETL code across various environments( Dev TEST PRE PROD PROD) and was involved in setting up of the Database environment (creating table structures, applying constraints etc).
  • Expertise in both dimensional and relational modeling concepts like star-schema modeling, snow flaking, ER modeling at logical, physical and presentation levels.
  • Expertise in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets.
  • Experience in implementing update strategies, incremental loads and change Data capture.
  • Experience in UNIX working environment, writing UNIX scripts for parsing and data modification, data validation and FTP.
  • Experienced working in fast paced environments demanding strong organizational, technical and inter personal skills. Trustworthy, ethical and discreet, exceptionally well organized with a track record that demonstrates self-motivation, creativity and initiative to achieve personal and organizational goals. Confident and poised in interactions with individuals at all levels
  • Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual. Experience in working with Off-shore and Near-shore models. Strong team player with excellent inter-personal, written and oral communication skills.
  • High ability to work on SOA and Agile projects.
  • Achieved as Informatica Certified Developer.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x, Datastage Server 7.5 and SSIS

Databases & Tools: Teradata 14,Oracle 8I,9I and 11g,DB29.1

GUI Tools: Visual Basic 6.0 and Developer 2000, Autosys, Control-M

Operating System: UNIX, Windows 7,Win NT, Win 95,98, 2000

Programming Languages: C, C++, SQL and PL/SQL.

Reporting Tools: Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr ETL Developer

Responsibilities:

  • Interacted with business and application architects for need analysis and to define Business and Functional Specifications. Participated in the Design team meetings and prepared technical design and source to target mapping documentation.
  • Created/modified and consolidated various Informatica Mappings and workflows for the successful migration of the data from various source systems to ODS which meets the business requirements for reporting and analysis.
  • Lead the ETL team (on-site + off-shore) during design discussions, impact analysis, challenge architectural/design decisions to provide easy, feasible and better solutions.
  • Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
  • Responsible for authoring project deliverables like mapping specifications, Installation verification documents for release validation, testing strategy approach, knowledge transfer documents and help production support team get up to speed.

Environment: Informatica Power Center 9.5.1, SSIS, Oracle's E-Business Suite, TOAD, UNIX, Erwin r9, Rally, Microsoft Visual Studio 2013

Confidential, Dallas, TX

Sr ETL Developer

Responsibilities:

  • Interacted with business analysts for Need Analysis and to define Business and Functional Specifications. Participated in the Design team meetings and prepared technical and mapping documentation.
  • Created/modified and consolidated various informatica Mappings and workflows for the successful migration of the data from various source systems to ODS which meets the business requirements for reporting and analysis.
  • Created multiple instances of a workflow to be able to run the workflow for multiple consumers concurrently and thus re-using the existing objects.
  • Parameterized various key variables to provide configurability and re-usability for the Informatica workflows developed.
  • Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, Removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Performed Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
  • Analyzed Session Log files, used debugger wizard in case the session fails in order to resolve errors in mapping or session configurations.
  • Lead the ETL team (on-site + off-shore) during design discussions, impact analysis, challenge architectural/design decisions to provide easy, feasible and better solutions.
  • Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
  • Responsible for authoring project deliverables like mapping specifications, Installation verification documents for release validation, testing strategy approach, knowledge transfer documents and help production support team get up to speed.

Environment: Informatica Power Center 9.5.1/9.1.1, Oracle 11g, Teradata 14.10, TOAD, UNIX, Microsoft Visual Studio 2008

Confidential

Sr ETL Developer

Responsibilities:

  • Interacted with Data Analysts and reviewed the profiling results in the Informatica analyst and worked closely with the BA’s and DA’s to define Functional and Informatica mapping Specifications. Participated in the Design team meetings and prepared technical and mapping documentation.
  • Created/modified and consolidated various type-I, type-II dimensional mappings and workflows for the successful migration of the data from various source systems to NFCU’s IDW which meets the business requirements for reporting and analysis.
  • Extensively used various Teradata features like TPT Export, TPT reader, TPT load, Teradata Query Banding, etc.
  • Extensively used Pushdown Optimization in Informatica for doing superfast loads.
  • Parameterized various key variables to provide configurability and re-usability for the Informatica workflows developed.
  • Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, Removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Implemented error handling routines in the Informatica mappings to capture anomalies in the source data and send notifications as needed.
  • Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
  • Responsible for authoring project deliverables like mapping specifications, knowledge transfer documents, Run Books and helped production support team get up to speed.

Environment: Informatica Power Center/Power Exchange 9.5.1, Teradata 14, Teradata SQL Assistant, SQL Server, Informatica DVO, UNIX, Mainframes, Quality Center 9.x, Serena Dimensions.

Confidential

Sr ETL Developer

Responsibilities:

  • Gathering the requirements, preparing Analysis and Low Level Design documents.
  • Design, Development, Testing and debugging the code.
  • Ensuring to follow all the coding standards and delivering the high quality code.
  • Preparation of Unit test cases and Test Reports and migration check list.
  • Executing QA loads through Autosys tool.
  • Perform migration activities, code Deployment and validation, folders, individual objects and shared objects across repositories.
  • Creating users, groups and providing access to group as per the request using Admin console, Managed permissions and privileges for user folders in different environment.
  • Create and maintain relational connections on different environment.
  • Create source and target objects in the shared folder as per the request from the developer.

Environment: Informatica Power Center 8.6.0/8.1.1, Oracle 10g, DB2, WinSQL, Oracle SQL Developer, UNIX.

Confidential

Sr ETL Developer

Responsibilities:

  • Involved in requirement gathering from the business users and converted them into mapping documentation.
  • Involved in reviewing BR’s, FR’s and TDD’s.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Rank Etc.
  • Wrote SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
  • Created complex transformations using connected/unconnected Lookups.
  • Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplets designer according to the business requirements.
  • Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
  • Performed Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
  • Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
  • Validate the updates in oracle schemas after workflow success.
  • Developed UNIX scripts for parsing & modifying data, data validation and FTP.
  • Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
  • Responsible for documenting project deliverables.

Environment: Informatica Power Center 8.1, DB2, UNIX, Autosys, MS Office, QC 9.0/9.2

Confidential

ETL Developer

Responsibilities:

  • Involved in reviewing BR’s, FR’s and TDD’s.
  • Initial design phase included identification of our Fact and Dimension tables.
  • Involved in installation and configuration of Informatica 7.1.2 and migrating repositories from 6.2 to 7.1.2.
  • Designing, developing and testing the different Mappings according to Requirements.
  • Used partitions like key range to improve the performance.
  • Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
  • Enhanced the existing Informatica mappings to meet the new requirements.
  • Wrote pre-session and post-session commands for processing shell scripts.
  • Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
  • Done extensive testing from the development side and wrote queries in SQL to ensure the loading of the data.
  • Written Complex SQL queries to validate source and target data using Toad.
  • Performed Data Validation and integration of the data by writing complex SQL queries and by verifying the data extracted in reports using Seibel interface.
  • Analyzed the PL/SQL code and convered the logic to Informatica mappings.
  • Wrote UNIX Shell Scripts to process text files.
  • Prepare and submit weekly status report, attend weekly and adhoc status meetings.

Environment: Informatica Power Center 6.2/7.1/8.1, Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX, Autosys, MS Office, ERWIN, Test Director 8.0/7.x/ 6.0 .

Hire Now