We provide IT Staff Augmentation Services!

Etl Design Lead Resume

SUMMARY:

  • Data Warehouse / BI professional with 6+ years of experience in managing and driving DI / DQ projects through planning, re - scoping, implementation, deployment, on-time and within budget.
  • Expertize in managing off-shore / on-shore resources to drive projects from analysis to fruition
  • Experience re-scoping and planning efforts and communicating, risk / issues and mitigation strategies to client
  • Experience defining Integration Architecture using leading practices
  • Travel ability: up to 100 %
  • Experience with proposals, and driving proof of concept / gap analysis / assessments and presenting to executives

TECHNICAL SKILLS:

Datawarehouse: Informatica PowerCenter 8.6, Informatica Data Quality (IDQ 9.1), IBM Quality Stage 9.1, IBM Information Analyzer 9.1, IBM DataStage 9.1, SSIS, SQL Server, ORACLE, TOAD, Datawarehouse Administrative Consol (DAC), TIDAL 6.0

BI Tools: Tableau(2015 trained), Cognos 10 (trained), Crystal Reports, SQL Server Reporting Services (SSRS)

Management: MS Project, GANTT charts

Other: SFDC (Veeva) Data Model concepts, Use Cases (not a primary skillset), Interface Design, Data Profiling, ERD / DFDs concepts, JAVA and NetBeans (not a primary skillset), C++(not a primary skillset)

PROFESSIONAL EXPERIENCE:

Confidential

ETL Design Lead

Responsibilities:

  • Defined Integration Architecture in response to RFPs
  • Built internal assets / POVs around various ETL / DQ tool capabilities
  • Provided mentorship and guidance through formal channels
  • Lead DQ tool Assessment to win $1.5M DQ implementation phase
  • Planned resource allocation, project timelines and managed risks/issues for a Salesforce (Veeva) / ICS based $600k Data Integration project
  • Lead $600K IBM Initiate MDM pilot engagement on an aggressive timeline
  • Managed end to end Delivery of DI solution through entire lifecycle to successful deployment of MDM Program (Informatica PowerCenter, DQ, and MDM)
  • Managed projects to schedule and priorities while driving re-scoping, risks / issues activities
  • Access existing ETL Architecture and propose a more robust ETL / DQ Architecture to client Technical Execs
  • Experience designing ETLs in relation to integration with SFDC (Veeva) as per Salesforce Data Model
  • Lead team of 8 through ETL Design/Build phase for PowerCenter and ICS data integration/transformation projects
  • Collaborated with Data Modeler to architect data models that can support different business models
  • Conducted KT sessions on: DAC, PeopleSoft Trees, CDC, investigating ETL errors, and SQL based data analysis, etc.

Technologies: Salesforce Veeva, Informatica Cloud Services (ICS), Informatica PowerCenter, Informatica Data QualityIBM DataStage, IBM Information Analyzer, IBM QualityStage

Confidential

DW/DQ Project Lead

Responsibilities:

  • Developed and documented SSIS ETL designs and test scripts based on business requirements
  • Supported SSIS development, solution configuration and troubleshooting for DW systems/solutions
  • Partnered with BI team to develop various SQL Server Reporting Services (SSRS) reports

Technologies: SQL Server, SSIS, ETL Design Documentation

Confidential

ETL Developer

Responsibilities:

  • Developed ETLs in Informatica 8.5/Oracle to support tracking of anti-money laundering activities
  • Performed Informatica Performance Tuning and extensive ORACLE SQL based unit/integration testing
  • Mentored and lead junior developers in ETL/DW concepts, ETL Guidelines, development, and testing
  • Documented ETL Designs (STMs, Design documents, etc.)
  • Co-ordinated migration/integration testing activities amongst 3 developers to meet tight deadlines

Technologies: SQL, Informatica, TOAD

Confidential

BI/DW Business Analyst

Responsibilities:

  • Developed Informatica PowerCenter 8.0 ETL transformations using mappings, maplets, sessions, workflows, unionizer, routers, lookups, etc.
  • Scripted SQL to perform Unit Testing and implemented ETL fixes (SQL correction, modifying / adding ETL transformations, etc.)
  • Developed SQL Server-SSRS parameterized ad-hoc report models and assisted with configuration of user-roles, groups and authentications using SQL Server Report Manager
  • Lead functional testing and Proof of concept phases for various projects / solution

Technologies: SQL, SQL Server Reporting Services, Informatica PowerCenter

Hire Now