Position Responsibilities

·        
Manage
data related requests, analyze issues and provide efficient resolution.
Design all program specifications and perform required tests.

·        
Prepare
codes for all modules according to require specification.

·        
Evaluate
all functional requirements and map documents and perform troubleshoot on all
development processes.

·        
Collaborate
with application groups to prepare effective solutions for all programs.

·        
Documents
all technical specifications and associate project deliverables.

·        
Design
all test cases to provide support to all systems and perform unit tests.

Position Qualifications

·        
Must have 6+ years of experience Teradata
in doing designing, development and implementation of ETL/Data warehouse
projects

·        
Bachelor’s Degree in Computer
Science, Engineering or other STEM programs preferred

·        
Must have Expertise in data
warehousing, ETL architecture, Data Profiling using Informatica PowerCenter/
Informatica Data Quality – Client and Server tools and building Design and
building Enterprise Data warehouse/Data Marts.

·        
Must have experience with in
Database design, entity relationship modeling and dimensional modeling using
Star and Snowflake schemas.

·        
Experience with mappings using
different transformations like Filter, Joiner, Router, Source Qualifier,
Expression, Union, Update Strategy, Unconnected / Connected Lookup,
Aggregator and SCD Type-2.

·        
Must have experience in loading
various data sources like Oracle, SQL Server, Teradata, DB2 and Flat Files
into DataMart’s.

·        
Must have experience in Performance
Tuning and Debugging of existing ETL processes.