We provide IT Staff Augmentation Services!

Sr.etl Consultant Resume Profile

4.00/5 (Submit Your Rating)

CA

Hire Now

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.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship