Job Description :
Title: ETL/Ab Initio Developer
Location: Hartford, CT
Duration: Full Time

Need : Green Card/Citizens

An Ab Initio Senior developer with primary focus of this position to provide technology suggestion, architectural guidance, technological recommendations and reusable solutions that support the development and implementation of DW/BI solutions in Business Insurance area.

Candidate must be experienced working in ETL based projects involving Ab Initio.
Must have expertise in the following:-
Ab Initio (Technical Expert)
Teradata (or equivalent RDBMS)
Understands where to obtain information needed to make the appropriate decisions
Demonstrates ability to break down a problem to manageable pieces and implement effective, timely solutions
Identifies the problem versus the symptom
Manages problems that require involvement of others to solve
Reaches sound decisions quickly
Carefully evaluates alternative risks and solutions before taking action
Optimizes the use of all available resources
Develops solutions to meet business needs that reflect a clear understanding of the objectives, practices and procedures of the corporation, department and business unit

Under the direction of the Portfolio Architect, assists with ETL design and solution
Should be able to provide data modeling solutions
Supports maintenance of plans to address significant architecture gaps between current and target state
Collaborates with business leaders to determine how to best use technology to enable growth and success (e.g. operational reporting and advanced analytics
Participates in defining and driving architecture competencies, processes, and best practices across Business Insurance.
Understands potential impacts of proposed solutions on other systems, processes or projects. Articulates and documents designs, considering tradeoffs, costs, and benefits.
Participates in day-to-day execution of the architecture strategy
Works within a single project to develop, communicate, and mentor others on design/implementation standards, guidelines and best practices
Stakeholder Management

6-8 years of work experience in Ab Initio
Experience of reporting tool (Cognos or equivalent)
Experience in Ab Inito & Big data Hadoop integration
Good analytical and logical skills in writing SQLs, Stored Procedures and creating Marts/Views in Oracle
A good end to end knowledge in ETL landscape; starting from source system, warehouse, mart and reports
Very strong ETL Concepts and hands-on experience on Ab Initio ETL Tool (Basic & Advanced)
4-year degree in a related field (or equivalent experience)
Experience working within a highly-matrixed organization
Strong communication and presentation skills
Hands on experience on data modeling with expertise on ERWin

Key Skills:
Ab Initio Senior Developer