Specialist - Data Engineering

Candidate must be experienced working in ETL based projects involving Ab Initio especially cloud exposure.

Location: Hartford, CT or St. Paul, Mn

Must have expertise in the following:-

• Ab Initio (Technical Expert)

• SQL Server (or equivalent RDBMS) or Teradata

Good to have: Snowflake, AWS

• Strong Ab Initio with 10+ years hands on experience

• Experience with designing, building or supporting complex AB Initio framework and plan

• Unix/Linux shell scripts

• Cloud experiences (AWS, S3, Ab initio running on EC2)

• Strong SQL skill (Snowflake experience is plus)

• Strong troubleshooting and issue resolution skill in ABI and other techniques interfaces with ABI

• Good communication and team working

• Inquisitive mind, motivation to learn, strive for quality work and is willing to go extra mile help

• May provide some technical guidance to offshore GSO.

• 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

Skills:

• 6-8 years of work experience in Ab Initio

• Proficient in SQL

• 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

Nearest Major Market: Hartford
Job Segment: Database, SQL, Warehouse, Business Intelligence, Data Warehouse, Technology, Manufacturing