We provide IT Staff Augmentation Services!

Sr.etl Consultant Resume Profile

4.00/5 (Submit Your Rating)

CA

Objective:

To obtain a position which leverages my technical expertise and educational background in Data warehousing and OLAP technology.

Summary:

  • More than 10 years of experience in IT field as a software engineer in various fields including Federal, Finance, Health insurance and Travel Industry.
  • 8 years of experience in Datawarehouse, Datamart and ETL development using InformaticaPowercenter 8.6/ 8.1/ 8.0/ 7.x/ 6.x and Data Integrator 11.7.
  • Strong educational background specialized in Computer Applications and Information Technology.
  • Extensively worked with Designer, Workflow Manager, Monitor, Repository Manager and Admin Console.
  • Self-motivated team player with excellent technical and problem solving skills.
  • Self-starter and quick-learner with ability to work independently.
  • Dependable team player with strong communication skills and development skills.

Skill Set:

ETL Tools:

InformaticaPowerCenter/Powermart 9.0/8.6/8.5/8.1/8.0 Designer,

Workflow Manager, Workflow Monitor, Repository manager and

Informatica Server , Debugger, Admin Console, RTM Service, Versioning, Business Objects Data Integrator 2.0,

Databases:

Oracle 10g/9i/8i,Peoplesoft, MS-SQL Server 2000/5/8, Informix 2.0, DB2,

Teradata, Sybase

Database Tools:

TOAD, SQL plus, SQL Developer, SQL Navigator, Rapid SQL, SQL Server ManagementStudio

Packages:

Lotus Notes, Sharepoint, MS-Word/Excel/Powerpoint/Outlook/Visio

Operating System:

WIN 95/98/NT/2000/XP/7/8, UNIX, Linux, AIX, HP-UX, MS-DOS

Unix Tools:

WinSCP, HP FTP Client, Humming Bird, Exceed, Putty

Text Editors:

UltraEdit, Notepad , Textpad, Editplus

Scheduling Tools:

Autosys, DAC, TWS

Reporting Tools:

Hyperion Smartview, OBIEE Dashboard Reports Analytics, Business Objects Reports Universes Migration

Models:

Kimball Model, Inmon Model, Star Schema, Snowflake Schema, Facts Dimension Tables

Others:

Clearcase, Clearquest, Dart, Doors, Remedy, Jira, HTML, XML

Work Summary

Confidential

Sr.ETL Consultant

  • Gather requirements, meet users and understand the business needs.
  • Do the complete analysis and provide solution for it.
  • Design and develop the solution through ETL and make sure it gets implemented correctly.
  • Verify with users and business to confirm if their needs are met.
  • Help other junior developers and provide the solutions to them.
  • Mentor other developers in implementing the solution through Informatica.
  • Help other developers in meeting deadlines.
  • Work on long term as well as short term projects which involve ETL as well as CDC solution.
  • Coordinating with other teams like Informatica Admin, Unix Admin etc to make them aware of the project, project needs, permissions and accesses.
  • Make sure we have all the required accesses and process works accurately.
  • Architect the ETL design and solution for project work.
  • Fix all the production break fixes, create CCB tickets and make sure that it gets approved.
  • Implement the solution with Informatica Admin and production deployment team.
  • Create necessary documentation including design, mapping, runbook and scheduling request form.
  • Help QA team in testing and understanding the requirements.
  • Follow Agile and Scrum process for project and communicate with whole team regarding the status, issue and ETL solutions.

Environment:InformaticaPowercenter 9.0.1, Toad 9.5, Toad 11.6, SQL Server 2008 R2, Oracle 10g, Putty, Flat Files, Exceed

Confidential

Sr. Software Engineer

  • Develop ETL/DI mappings, unit test it and make sure it gets implemented correctly all the way to PROD.
  • Provide QA, UAT and PROD support.
  • Fix ETL defects in DI/DB as well as successfully implement it in other environments.
  • Upgraded Data Integrator v2 to Data Services v3.
  • Upgraded ETL repository from SQL Server 2005 to SQL Server 2008.
  • Setup virtual server on Windows 2008 and installed DS 3.2.
  • Migrated the code and upgraded the DI local and central repository on SQL Server 2008.
  • Setup virtual client on Windows 7 machine and created the connectivity by troubleshooting many issues.
  • Created Job server and configured client and server to make sure that the code is working on upgraded version at both server and client machines.
  • Tested heavy data load to make sure that civil and criminal job works and made the management aware of the risk of bad performance.
  • Worked on many civil CQ tickets from DEV to its implementation in PROD including its LOE, analysis, design, development, unit testing and deployment in all environments.
  • Worked with client to understand the requirements through meetings, discussions and emails.
  • Assisting the Govt. employees and documented the CM Configuration Management process workflow as well as provided inputs based on my experience and knowledge in it.
  • Analyse the existing system and fix the Clearquest Tickets in DI ETL/Informix DB.
  • Gather requirements from business users as well as coordinate with BA regarding business needs.
  • Migrate ETL/DI Data Integrator objects from Central Repository to Local Repositories Test/PROD .
  • Migrate Reports and Universes / BI Business Intelligence from DEV to TEST and TEST to PROD.
  • Coordinate with team for all the test and production deployments.
  • Create BIAR files and take the backup for reports and universes.
  • Maintain configuration management protocols and keep the clearcase versioning in sync with the PROD environments.
  • Make sure that daily production load is completed successfully.
  • Mentor junior developers and help them in ETL solutions.

Environment: Business Objects Data Integrator 11.7.3.5, Informix 10, SQL Developer 2005, WinSCP FTP Client, Clearcase, Clearquest, Flat Files, Documentum, DB Visualizer 8.0.8.

We'd love your feedback!