We provide IT Staff Augmentation Services!

Dwh Dev Lead Resume

Atlanta, GA

PROFESSIONAL SUMMARY:

  • Over 8 years of Information Technology experience in Data Warehousing and Business Intelligence
  • Strong Experience in INFORMATICA, MDM, Teradata and Oracle.
  • Extensively used ETL methodology for supporting data extraction, transformation and loading process in a corporate - wide ETL Solution using Informatica.
  • Strong ETL Experience in Designing, Developing and Implementation of Data Warehouses & Data Marts with ETL solutions using Informatica Power Center 8.x/9.x.
  • Participated in all levels of SDLC like requirements gathering, Preparing Technical Documentation, Development, Testing, Production Implementation and Maintenance.
  • Experience in (Workflow Manager, workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer) in Informatica Power Centre 8.x/9.x.
  • Experience in designing and developing complex mappings from varied transformation logic like lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer, SQL Transformation.
  • Extensive experience in design and development of ETL processes from different heterogeneous source systems like Oracle, Flat files.
  • Configuring Informatica Server and scheduled Workflows and sessions using Informatica Power Center.
  • Experience in developing mappings involving Type1 SCD, Type2 SCD and Type3 SCD.
  • Developed entire MDM flow like Loading to landing tables, creating Mappings for implementing cleansing and stage load, executing Match/Merge progress, validating Base object load
  • Thoroughly proficient in SQL development in Oracle, Teradata.
  • Knowledge on Data profiling and Data cleansing using Informatica tools.
  • Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
  • Improved ETL performance by implementing Archival strategy, partitioning etc.
  • Good knowledge of Data warehouse concepts and principals (Ralph Kimball / Inman), Star Schema, Snowflake, SCD, Surrogate keys.
  • Expertise in designing and writing on-demand UNIX shell scripts.
  • Hands on experience with Teradata utilities like bteq, fast export, fast load and multi load.
  • Extensive experience in Production Support & Supporting Application as per SLA.
  • Team player and self-starter and ability to work independently and as part of a team.
  • Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
  • Experienced in Onsite Offshore model coordinating with development/support activities.

TECHNICAL SKILL SET:

ETL Tools: Informatica (Power Center 8.x/9.x),MDM, Abinitio (GDE 3.2)

Databases: Oracle 10g/11, Teradata

Job Scheduler: Cron Scheduler, Control-M,Autosys

Data modeling Tools: Erwin 4.0 and Microsoft Visio

Programming Languages: SQL, PL/SQL

Scripting Languages: UNIX/LINUX, PL/SQL

PROJECT EXPERIENCE:

Confidential, Atlanta, GA

DWH Dev lead

Responsibilities

  • Responsibility in this project involves Creation of Requirement, TSD, FDD and Traceability matrix
  • Aanalyzing teh incoming Source data, designing and performing independent unit testing.
  • Responsibilities also include Development, preparation of Defect Analysis, Unit Test & Release Manual documents.
  • Onsite -Offshore coordination, client interacting, bug-fix request, and implementation support

Confidential

Associate -ICDW Production support & Analyst

Responsibilities

  • Monitoring teh Daily loads and Production Environment.
  • Identifying teh reoccurring issues and fixing code issues through ITSM
  • Implemented teh password parameterization for teh Teradata ETLs in teh Informatica with EPV
  • Providing teh second level support for teh ICDW applications, job scheduling, change and incident support and handling user queries.
  • Handling code promotion, change and problem management, incident management, EURC request management, job scheduling, file and database table management, transfer/load/extract data management, application wellness checks, daily status reporting, application recovery, and disaster recovery.
  • Documenting all teh failures, corresponding resolution steps and code fixes for future reference.
  • Handling Informatica and Database version upgrades.
  • Handling teh P1 calls with teh halp of PAC team
  • Handling loads during outages and maintenance activities

Confidential

Associate Consultant

Responsibilities

  • Developing teh Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source Flat files and RDBMS tables to target flat files and tables using teh transformations
  • Attending Requirement calls with BA’s and Understanding teh Requirements as per teh FRD (Functional Requirements Doc) and preparing Issue Tracker to minimize teh Requirement Gaps with BA’s.
  • Performing UT and doing peer reviews
  • Monitoring teh ETL flow and troubleshooting teh issues
  • Involved in Unit testing and System testing of teh individual.
  • Analyzed existing system and developed business documentation on changes required.
  • performed detail data analysis of both data elements requested by teh business and data source and documenting data source definition, source-to-target mapping, and logical structures for teh data warehouse
  • Worked with many existing Informatica mappings to produce correct output.
  • Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for teh developed code.
  • Loaded data from Different Formats of Source files to Target tables.
  • Helped Production Support team to solve teh job failures in production and gave them teh resolutions if it happens again.

Confidential

Software Engineer

Responsibilities

  • Understanding teh Business Requirements and Develop an ETL process to load data from source to target.
  • Extensively used Informatica power centre for loading teh data from sources involving flat files to load into target.
  • Mainly involved in ETL developing to Extract, Transform and Load teh data into Target.
  • Creation of sessions for mapping and validate teh session.
  • Prepare teh T100 Document and review teh documents.
  • Prepare teh Test case documents and load to teh QC.
  • Involved in SIT&UAT Testing.
  • Identified teh granularity level of teh data required to be available for analysis.
  • Reviewing teh code and performing Unit test.
  • Providing Application Support
  • Participating in Design and Code reviews
  • Providing Effort Estimation for teh Mappings, Sessions, Workflows creation as part of development based on functional point analysis
  • Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation.
  • Masked data in tables in pre-prod environments to protect PII information.

Confidential

Analyst Programmer

Responsibilities

  • Understanding teh Business Requirements and Develop an ETL process to load data from source to target.
  • Extensively used Informatica power centre for loading teh data from sources involving flat files to load into target.
  • Mainly involved in ETL developing to Extract, Transform and Load teh data into Target.
  • Creation of sessions for mapping and validate teh session.
  • Prepare teh T100 Document and review teh documents.
  • Prepare teh Test case documents and load to teh QC.
  • Involved in SIT&UAT Testing
  • Reviewing teh code and performing Unit test.
  • Providing Application Support
  • Participating in Design and Code reviews
  • Providing Effort Estimation for teh Mappings, Sessions, Workflows creation as part of development based on functional point analysis

Confidential

Informatica Developer

Responsibilities

  • Understanding of teh Analysis and design documents.
  • Prepared Technical Design Document
  • Involved in Development of Informatica Mappings using different transformations.
  • Used Informatica Workflow manager to create sessions, Workflows to run with teh logic embedded in teh mappings.
  • Developed reusable mapplets using maplet designer.
  • Involved in Unit Testing and prepare test cases
  • Responsible for teh maintenance (Backup, Restore).
  • Involved in thePerformance Tuningof Mappings and Sessions. Involved in automating teh Informatica process by using Unix Shell Script.
  • Used InformaticaDebuggerto validate and test business logic implemented in teh mappings and fix teh bugs.

Hire Now