We provide IT Staff Augmentation Services!

Architect( Data Management & Etl) Resume

SUMMARY:

  • 13+ years of Software industry experience with extensive 7+ years in Data Warehouse development and production support using various ETL & BI Tools in multi - platform environments
  • 12+ years of ETL design, development experience using Informatica,and Oracle PL/SQL
  • An effective Leader with proven abilities in leading teams, training, mentoring and guiding team members and enabling knowledge sharing among the team
  • I have experience in varied industries including Telecom, Media, Pharmacy, Financial services, Insurance and Logistics. I have worked with customers across the globe, and have been instrumental in setting up strong foundations for long term work relationships in my last couple of roles.

IT SKILLS:

  • ETLInformatica 6.x 7.x & 8.x, 9.x, Power Centre, Power Exchange,Datastage 8.5,Talend
  • Oracle 8i, 9i and 10G, SQL, PL/SQL, SQL Server
  • Unix Shell scripting
  • ETL-Informatica, Oracle PL/SQL, DataStage 8.5
  • Java
  • Hadoop, Hortonworks 2.4, sqoop, HBASEand Hive
  • Agile and Waterfall methodolgies

PROFESSIONAL EXPERIENCE:

Confidential

Architect( Data Management & ETL)

PlatForm: Informatica 9 Powercentre, Oracle 11.2 Oracle Enterprise Data Quality(EDQ), AWS,ERWIN 7.3.4, Power exchange

Responsibilities:

  • Analyzing Reporting requirements for data integration
  • Conducted JAD sessions with business users and SME's for better understanding of requirements
  • Deliver Detailed Design document
  • Design Data model for staging, ODS & data mart
  • Present Solution design to the Customer and get sign off
  • Design & Develop solution to generate unique customer id using Oracle Enterprise Data Quality
  • Design & Developed EDQ jobs for address standardization using LOQATE
  • Design ETL using sqoop to ingest data in hadoop on AWS
  • Provide estimates for development
  • Communicate project status and provide timely escalation of issues, deviations to requirements
  • Provide guidance to development team during the build
  • Data Modeling, Dimension Modeling, Database Designing.
  • Assign & review work of offshore team

Confidential

Lead Data Quality Solution Design Architect

PlatForm: Informatica 9 Powercentre, Teradata, Informatica IDQ

Responsibilities:

  • Lead Solution Design for data quality rules using Informatica IDQ (Developer and Analyst)
  • Liaised with Business Analysts, QA Analysts & DBA throughout project lifecycle to ensure project requirements are met.
  • Develop, execute and evaluate data quality test plans as well as the results and quality of the data as per business needs.
  • Provide guidance for IDQ development team

Confidential

Architect( Data Management & ETL)

PlatForm: Informatica 9 Powercentre, Oracle 11G, Informatica IDQ, Power exchange

Responsibilities:

  • Solution design for DWBI.
  • Develop, execute and evaluate data quality test plans as well as the results and quality of the data assuring compliance with business expectations.
  • Perform systems and data analysis to Develop ETL design.
  • Develop technical specifications for data acquisition, transformation, and load processes from a variety of sources
  • Analyze performance bottlenecks and provide solution for performance improvements
  • Provide effort estimates for new projects and initiatives
  • Present Senior Management Technical solution options in key projects.
  • Represent the Project team in Quality Assurance meetings.
  • Involved in Data Discovery phase of key projects.
  • Liaised with Business Analysts, QA Analysts & DBA throughout project lifecycle to ensure project requirements are met.

Confidential

Role: Data Architect

PlatForm: Informatica 8.6 Powercentre, Oracle 10G, HP Quality Centre,Autosys, Erwin 7.3.4,Power exchange

Responsibilities:

  • Analyzing Reporting requirements for Employee Compliance data mart
  • Source system Analysis
  • Prepare Source to Target mapping
  • Design Logical & Physical Data model for staging, ODS & data mart

Confidential

ETL Solution Architect

PlatForm: Informatica 9 Powercentre, Oracle 10G, HP Quality Centre,Autosys, IDQ

Responsibilities:

  • Analyzing Business requirements for data integration
  • Solution Design for integrating data from desperate sources.
  • Design & Implement Customer Contact Data Quality validation using Informatica Data Quality
  • Prepare Detailed Design documents
  • Present Solution design to Confidential Solution design team for approval.
  • Design Data model for staging, ODS & data mart
  • Liaised with business teams to ensure project success.
  • Provide estimates for development
  • Communicate project status and provide timely escalation of issues, deviations to requirements
  • Provide guidance to development team during the build
  • Assign & review work of offshore team

Confidential

Technical Project Lead

PlatForm: Datastage 8.5, Oracle 10G, HP Quality Centre,Autosys

Responsibilities:

  • Build credibility, establish rapport, and maintain communication with Project Manager to keep him updated on issues and risk factors through careful analysis to anticipated and manage change in the requirements
  • Analyse and escalate issues & incidents and track those to the closure
  • Interacting with Development, Configuration and QA team during execution
  • Help Project Manager Create Dashboards for weekly and Monthly Status reporting to the Director
  • Release planning with Project Manager, sign off and Management
  • Review ETL design
  • Review & Test ETL code developed in pl/sql
  • Responsible for Quality and timeliness for all deliverables

Confidential

Technical Project Manager

PlatForm: DataStage 8.5,Oracle 10G, Clarity, Quality Centre, MS-Office,Cognos 8,Erwin 7

Responsibilities:

  • Interacting with Development team in India for Status and Project meetings
  • Utilized Quality Centre for requirement and defect tracking during a project SDLC
  • Prepare logical Data Model and review with the Lead Data Architect
  • Developed key mappings to Load data into Aggregate Fact Tables
  • Develop ETL Design
  • Review & Close ETL design with Solution Architect
  • Estimate Development Effort
  • Coach, mentor and lead personnel within a technical team environment.
  • Responsible for the recruiting, management and career development of consulting staff.

Technical Project Manager

Confidential

PlatForm: DataStage 8.5, Oracle 10G, Clarity, Quality Centre, MS-Office,Cognos 8

Responsibilities:

  • Report design review
  • Review the team’s work on Analysis/Coding/ Testing and production rollout.
  • Developed ETL design.
  • Prepare logical Data Model and review with the Lead Data Architect
  • Provide Estimate for ETL & Cognos Report Design.
  • Track and improve team performance. Managing Vendors.
  • Identify areas of improvement in the project processes & implementing the required actions.
  • Meet project Quality objectives and ensure zero post implementation defects.
  • Review & ensure closure of all SEPG project audit points.
  • Responsible for hiring initiatives & defining of KRAs; to be used for direct reports reviews, appraisals and creation of development plans.

Confidential

Technical Lead/Lead Developer as part of the Falcon project for the client Datascan technologies USA

Platform: Informatica 6.2, Oracle 9i, Cognos 7.3, Autosys

Responsibilities:

  • Requirement Analysis, Team Management, Coding, Code Reviews, Unit Testing other Project Document review
  • Estimation using FP.
  • Managing a team of 8-10 personnel.
  • Interacting with client, on-site Confidential peers and QA teams.
  • Reviewing the code and documentation.
  • Developed ETL design Data Mart Layer
  • Provide estimates for development.
  • Tuning existing PL/SQL ETL programs to improve monthly ETL performance.
  • Analyzed the functional specs provided by the business users and created technical specs documents for all the mappings and Design high level document to low level document.
  • Involved in developing Informatica mappings based on documents that are developed during analysis.
  • Created Mapplet and used them in different Mappings.
  • Review ETL mappings

Hire Now