We provide IT Staff Augmentation Services!

Sr. Etl Consultant Resume

NJ

SUMMARY

  • Over 11 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions.
  • Extensive experience in developing scalable enterprise applications to the user needs which serves for Food & Beverages, Travel, Financial, Automotive Intelligence, Bank and PCB Manufacturing Industries.
  • Expertise in Data warehousing experience using Informatica Power Center / Power Mart 6.2.2/6.1/5.1.1/5.0.
  • Extensive knowledge of IBM’s AS/400 tool using RPG, RPGLE, CL, CLLE, and DBU.
  • Knowledge and Experience of front - end tools like Developer 2000, Genesis 2000 and Oracle 9i.
  • Highly skilled in Planning, Designing, developing and deploying Data warehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool ERWin (Physical and Logical data models).
  • Designed and Developed Data Marts by Following Star Schema and Snow Flake Schema methodology, using Data modeling tool ERWin 4.0/4.2.
  • Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using PL/SQL.
  • Involved in implementation of ISO 9001-2000 QMS.
  • Good communication skills and has ability to implement projects with demanding objectives.

TECHNICAL SKILLS

Operating Systems: Windows95/98/2000/XP, Windows NT 4.0, AS/400 (Mid-Range), MAINFRAME, UNIX, DOS

ETL Tools: Informatica Power Mart 5x & Power Center v8x/v7x/v6x/v5x

Data Modeling Tool: ERWin 3.5.2/4.0/4.2 , Embarcadero 8.5

Databases: Oracle 7.3/8i/9i/10g/11g, SQL/400, DB2, MS Access

Languages: RPG, RPGLE, CL, COBOL, Java, PL/SQL, SDA, RLU, SEU, PDM, Fortran, FoxPro, TSO/ISPF, Pascal

Front End: Developer 2000

Software: Turnover tool, Hawkeye tool, GENESIS 2000, StarTeam 2005, eRoom, Caliber, TTU (Teradata Tools & Utilities)

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. ETL Consultant

Environment: -Informatica Power Center 8.1.6, Micrsoft SQL Server 2005/2008, SQL Server Management Studio, Quest Software (TOAD for Data Analyst 2.7), DB2, HP-UX B.11.11 U(Shell script), AIX, Autosys, JIRA, SharePoint, Discovery, Eclipse 3.3.2(CVS), Windows XP

Responsibilities:

  • Working Currently Working on analyzing various SQLs, which run on daily base as well as for month end as part of CEM and IMM application, and converting them into data flow diagram for senior leadership presentation.
  • Working closely with Business Analyst to gather requirements and framing it into design specification.
  • Also working on generating Pre-Close checks report via Informatica ETL tool, which is currently accomplished via running bunch of SQLs onto SQL server.
  • Worked on existing production issues for sql scripts such as “Silent Failure” and implemented permanent fix to log syntax errors, logic errors and run-time errors into error log table.
  • Created new SQL procedures to populate a new date control table that can be used to schedule CEM/IMM legacy jobs.
  • Made use of JIRA application to log production bugs or enhancement project, so that it can be tracked through out different phases of SDLC.
  • Working CEM/IMM re-write project to re-platform legacy CEM/IMM processes from SQL server 2008 into Informatica ETL mappings.
  • For CEM/IMM re-write project constructed Source to Target matrix specs.
  • Also worked on stream lining of existing sql scripts to get the best performance when incorporating the same logic using Informatica ETL tool.
  • Also completed velocity documents which covers low level design for the actual mappings along with recovery process logic in case of failure, unix wrapper script, mapping parameters.
  • Along with CEM/IMM re-write project, also worked on CEM/IMM month end close process.
  • Developed jil scripts to install new autosys jobs and also modified existing autosys jobs.
  • Designing and developing mappings using mapplets.
  • Widely used of Shared folders, project folders and short cuts to maintain integrity between development, test and production repository.
  • Responsible for making master deployment sheet and back out checklist for scheduled production releases.

Confidential

Sr. ETL Consultant (Team Lead)

Environment: -Informatica Power Center 8.1.1, Power Center Connect for JMS 8.1.1, Oracle 11G, SQL*Plus, PL/SQL, TOAD 8.0, Teradata Tools & Utilities, Embarcadero 8.5, HP-UX B.11.11 U(Shell script), AIX, Control-M, Autosys, eRoom, STARTEAM 2005 (v7.0.133), SmartFTP v1.5, Caliber v6.5 SP2, Windows XP

Responsibilities:

  • Working closely with business users and business analyst to gather requirements and framing it into design specification.
  • Extensively making use of Informatica Power Center 8.1.1 as ETL tool to load tab delimited and XML files receiving from bottler system via ECG system.
  • Working with Caliber RM tool to get the business requirement and implement once it gets approved.
  • Worked extensively on Invoice and Customer subject area and acquired wide knowledge on Business.
  • Responsible for ramping up new developers and enlighten with specific business processes.
  • Worked extensively on different types of transformations like source qualifier, expression, lookup (connected & unconnected), stored procedure, joiner and union transformation.
  • Designing and developing complex mappings using mapplets.
  • Widely used of Shared folders, project folders and short cuts to maintain integrity between development, test and production repository.
  • Responsible for informatica code migration from development to Test, QA, Performance, and Data Validation environment and played the role of informatica admin.
  • Created sessions and batches within a batch at required frequency.
  • Frequently using import & export utility to migrate session from developer’s folder to subject folder.
  • Extensively making use of Power connects for JMS to write Log and Exception messages to JMS CommonLE server.
  • Generating Bluebook flat files for Pepsi Enterprise Data Warehouse (PEDW) based Functional mapping documents.
  • Extensively used control-m scheduler to monitor the jobs as well as add new jobs.
  • Extensively used parameter file to pass mapping and session variables.
  • Involved in many technical decisions and prepared technical design document for ETL Tech Architect.
  • Working as an individual team member to develop most of the process as well as working in a team to co-ordinate with other team members.
  • Responsible for handling unit test, functional test, integration test and system test depending upon the environments along with testing team.
  • Creating views, tables, materialized views using TOAD.
  • Updated mappings and transformation with necessary comments to track of revision history and logic being used.
  • Also taking care of additional requirements through various Change Requests and adding new codes and raising migration request to promote the code to other environments.
  • Knowledge of Autosys scheduler for our bridging jobs.
  • Working with business users to provide more technical details in business terms to better understanding of the technical processes.
  • Assigned with various medium sized projects and completed them successfully with team members and successfully deployed them into Production.
  • Responsible for working on new enhancements making sure no impact to existing developed system.
  • Applied performance tuning to existing developed system to make better use of the job schedule.

Confidential

Sr. ETL Developer

Environment: -Informatica Power Mart 5.1.2, Informatica Power Center 7.1, Oracle 9i, SQL*Plus, PL/SQL, TOAD 8.0, AIX 3.2 (PERL script), Windows 2000

Responsibilities:

  • Worked with business analyst to gather requirements and framing it in technical design specification.
  • Extensively making use of Informatica Power Mart 5.1.2 as ETL tool to load delimited and fixed width files receiving from AS/400 system.
  • Loaded flat files to staging schema. Using business rules as per technical design specification to load data from staging to dimension and fact tables.
  • Developed documents to set up CONTROL - M jobs to schedule Informatica batches and workflows to run at required frequency.
  • Worked extensively on different types of transformations like source qualifier, expression, lookup (connected & unconnected), stored procedure and joiner.
  • Designed and developed complex mapping using mapplets.
  • Widely used of Shared folders, project folders and short cuts to maintain integrity between development, test and production repository.
  • Worked closely with administrator to migrate mappings from development to testing environment.
  • Created sessions and batches within a batch at required frequency.
  • Implemented concurrent and sequential batch using Power Mart Server Manager 5.1.2.
  • Frequently used import & export utility to migrate session from developer’s folder to subject folder.
  • Polled the Informatica server, monitoring a session to troubleshoot sessions and to improve session performance.
  • Extensively used parameter file to pass mapping and session variables.
  • Involved in analyzing development, test & production repositories before kicking off up gradation to Informatica 7.1.
  • Involved in up gradation issue as well as post up gradation issue.
  • Developed PERL scripts to remove unwanted hex characters such as Line feed and carriage return from a delimited flat file.
  • Performed unit testing before promoting it to test environment.
  • Created views, tables, materialized views using TOAD.
  • Updated mappings and transformation with necessary comments to track of revision history and logic being used.
  • Also took care of enhancement to existing applications by various Magic Tickets and adding new codes and raising change control request to promote the code to Production.

Hire Now