We provide IT Staff Augmentation Services!

Senior Etl Consultant Resume

SUMMARY

  • 13 years of IT experience in total
  • 12 years of extensive experience in designing, developing and implementing Data Warehouse Projects using Informatica, Oracle & Unix shell scripting
  • 1 year of Informatica Administration & MDM experience
  • 1 year of BI consulting experience in Financial services sector
  • 2 years of Master Data Management consulting experience in Insurance Services sector
  • Good experience in Planning & Efforts estimation
  • Expertise in Business Requirement gathering and converting the same into Technical Specification documents (HLD & LLD)
  • Possess excellent interpersonal and communication skills, quick learner, teamwork minded

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.5.1/9.0.1/8.6.1/8.1.1/7.1.3/6.0/5.1 , Informatica Powerexchange, Business Objects XI, Trillium, Informatica MDM Multidomain Edition 9.5.1

Database: Oracle Exadata/10g/9i/8i, DB2, Sqlserver, Salesforce.com, Postgres

Languages: Unix shell scripting, SQL, PL/SQL

Operating Systems: HP - UX 11i, IBM AIX 5.1/5.2/5.3

Scheduling Tools: Tidal, Unicenter Autosys, Maestro Scheduler

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Consultant

Responsibilities:

  • Acted as the Technical lead for the ETL team comprised of both internal and contractor developer, creating and maintaining business intelligence and data warehousing design principles using industry leading practices
  • Provided technical leadership and guidance to the development team for the design and development of highly complex or critical ETL architecture and leading industry practices
  • Collaborated with project, architecture, and release teams, providing input on architectural design recommendations, driving standards, plan and execute effective transition to production operations
  • Studied the existing source systems, analysed the business requirements & prepared ETL Specifications
  • Explored the Salesforce.com application, created POC mappings to verify Salesforce integration using Informatica
  • Designed ETL framework to integrate data from various source systems such as Postgres, DB2, Files into Salesforce.com
  • Designed & implemented the following concepts:
  • Automatic reprocessing of salesforce rejections
  • Data Threshold governance
  • Table driven parallelization
  • Configured Webservices consumer transformation to read data from Workday system
  • Analyzed the Change request/Defects. Conducted meetings with BAs, DBAs & Tech leads to finalize the design & implementation
  • Hands on Experience in Informatica PowerCenter Administration
  • Installed Informatica 9.0.1 in Unix Platform
  • Experience with Informartica PowerExchange, pmcmd command line interface, and Security (including Native and LDAP security)
  • Installed and configured LDAP, Sales Force & Web-service Plugins with Power Center
  • Extensively worked on Powercenter upgrade from 9.0.1 to 9.5.1HF3
  • Created Deployment groups for code promotion
  • Performed the activities like User creation, Recycling/Disabling services through Informatica Admin console
  • Hands on experience working in Informatica MDM
  • Created Data model elements, Defined relationships & lookups within the Data model using Hub console schema tool
  • Configured mappings that use Functions and Cleanse Lists, setting options for Delta detection, Raw data detention using mapping tool
  • Configured exact matching, fuzzy matching & merge processes using the Schema tool
  • Configured Batch jobs to execute the stage, load, match & merge processes

Confidential

ETL Lead

Responsibilities:

  • Analysed the ESM & CHORUS Feed thoroughly before loading the data into ODH
  • Responsible for loading static data from ESM & CHORUS into ODH, which then, allows ODH to do necessary data mapping
  • Actively participated in analysis of ISTAR & DOLPHIN data feed via ODH
  • Responsible to generate position & margin feed of ISTAR & DOLPHIN systems from ODH & send them to TDB

Confidential

ETL Lead

Responsibilities:

  • Understanding and analyzing new and changing business requirements for adding new source systems and their impact on the Confidential design. Proposing enhancements and changes to the technical and business solution to meet the new requirements.
  • Estimated Efforts accurately & actively worked with PM’s in completing the project plan
  • Involved in discussion with Confidential SME’s to finalise the design of integrating the new source systems in Confidential platform. Managed the Design of taxonomy logic for few source systems
  • Coordinated with Offshore team & made sure to clarify their Design & Requirement queries. Worked with Tidal administrators to implement some complicated scheduling design
  • Conducted meeting with QA to demonstrate the design for each source systems. Provided support to QA for SIT releases. Promptly responded back to the users during UAT
  • Actively monitored the releases into higher environments. Participated in all production release calls & cleared the issues that arises during the release

Hire Now