We provide IT Staff Augmentation Services!

Etl Developer/onsite Coordinator Resume

Hartford, CT

PROFESSIONAL SUMMARY:

  • I have 7+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
  • 7+ years of ETL and data integration experience in developing ETL mappings/jobs and scripts using Informatica PowerCenter 8.x/9.x/10.x and Datastage 8.x/9.x.
  • Experience in working both Agile and Waterfall models. Also expertise in working both small mod and large development efforts.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Knowledge on Data modeling such as logical (LDM) and physical data model (PDM).
  • Experience in working with business analysts to identify and understand requirements and translated them into Baselined RSM in Requirement Analysis phase.
  • Experience in creating High Level Design and Detailed Design documents in the Design phase.
  • Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
  • Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding .
  • Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files.
  • Developed mappings using different transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator and Normalizer) in Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
  • Experience in integration of various data sources like Oracle, DB2, Netezza, SQL server and non-relational sources like flat files into staging area.
  • Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tool (Control-M v7/v8), CA WA Workstation (ESP).
  • Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate. Have used Winscp to migrate Unix components and Beyond Compare to compare dsx and other files.
  • Experience in support and knowledge transfer to the production team.
  • Extensive functional and technical exposure. Experience working on high-visibility projects
  • Assign work and provide technical oversight to onshore and offshore developers
  • Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere DataStage 9.1/ 8.5 / 8.0.1 , Informatica Powercenter 9.1/ 8.6.1

Database: Oracle 10g/9i/8i, IBM DB2/UDB, Netezza, SQL Server 2003/2005/2008

Star & Snow: Flake schema Modeling, Fact and Dimensions, Physical and Logical Data Modeling, OLAP & OLTP.

Operating systems: Windows 7x/NT/XP, UNIX, LINUX, MS-DOS, MS Access

Control: M v7/v8, CA WA Workstation (ESP)

Languages/Scripting: C, C++, PL/SQL, UNIX Shell scripts

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

ETL Developer/Onsite coordinator

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Developed Oracle stored procedures and created materialized view query to implement the business requirements for better performance than ETL.
  • Involved in creating UNIX shell scripts for Informatica workflow execution.
  • Effectively used Oracle to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed ESP jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, system testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Informatica v9.1/v10.1, CA WA Workstation (ESP), Toad for Oracle 12.6, Putty, Winscp, JBoss

Database: Oracle 12.6

Confidential, San Antonio, TX

ETL Developer/Onsite coordinator

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
  • Developed ETL programs using Informatica and Datastage to implement the business requirements.
  • Involved in creating UNIX shell scripts for Datastage job and Informatica workflow execution.
  • Developed hadoop components to archive source files into external hive tables.
  • Effectively used Squirrel to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed Control-M jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, system testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Datastage 9.x, Informatica 9.x, Control-M v8, Squirrel, Putty, Winscp

Database: IBM Netezza, Oracle, SQL Server

Confidential, San Antonio, TX

ETL Developer/Onsite coordinator

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Involved in creating UNIX shell scripts for Datastage job and Informatica workflow execution.
  • Effectively used Squirrel to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed Control-M jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, system testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Informatica 9.x, Control-M v7, Squirrel, Putty, Winscp

Database: IBM Netezza

Confidential, San Antonio, TX

ETL Developer/Onsite coordinator

Responsibilities:

  • Involved in all iterative phases from story building, development, testing, Production and support for production environment.
  • Developed ETL programs using Datastage to implement the business requirements.
  • Involved in creating UNIX shell scripts for Datastage job and Informatica workflow execution.
  • Effectively used Squirrel to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed Control-M jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, pre-prod testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Datastage 8.x, Control-M v7, Squirrel, Putty, Winscp

Database: IBM DB2

Confidential, San Antonio, TX

ETL Developer/Offshore

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Involved in creating UNIX shell scripts for Datastage job and Informatica workflow execution.
  • Effectively used Squirrel to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed Control-M jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, system testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Informatica 8.x, Control-M v7, Squirrel, Putty, Winscp

Database: IBM DB2

Confidential, San Antonio, TX

ETL Developer/Offshore

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
  • Developed ETL programs using Datastage to implement the business requirements.
  • Involved in creating UNIX shell scripts for Datastage job and Informatica workflow execution.
  • Effectively used Squirrel to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed Control-M jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, system testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Datastage 8.x, Control-M v7, Squirrel, Putty, Winscp

Database: IBM DB2

Confidential, San Antonio, TX

ETL Developer, Offshore

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
  • Developed ETL programs using Datastage to implement the business requirements.
  • Involved in creating UNIX shell scripts for Datastage job and Informatica workflow execution.
  • Effectively used Squirrel to validate data loaded into the target tables by writing simple and complex SQL’s.
  • Developed Control-M jobs using different scheduling conditions, Quantitative and Control resources, On Do Actions, etc.
  • Involved in different testing phases like unit testing, system testing and warranty support. Involved in creating UTP and UTR during unit testing.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Hardware: UNIX / LINUX Servers

Operating System: Microsoft Windows XP Professional, UNIX

Languages: UNIX Shell Scripting

Special Software: Datastage 8.x, Control-M v7, Squirrel, Putty, Winscp

Database: IBM DB2

Hire Now