Previous Job
Ab Initio Senior Developer
Ref No.: 18-00149
Location: Saint Paul, Minnesota
Position Type:Direct Placement
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.
Hands on expertise on Cognos 10 BI
Good exposure on Cognos Transformer
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)
• Cognos
• 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