Job Description :
Welcome to the CANA-H2R family. Let us assist you in experiencing the ''role of a lifetime'' that you have only heard of from the network or read in media. Join a global family of 150000+ professionals leading the IT industry through decades of experience in providing high-end solutions, next generation services, support, innovation, training etc. Join a company that has committed to hiring 10,000 workers in USA in the next two years. Be part of a company that has federal support for their commitment to opening four state of the art technology centers across the USA.

COME AND JOIN | CANA-H2R is hiring AbInitio ETL Developer for a full time Permanent role with one our client at Northbrook, IL.

Job Description:

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
At least 3+ years of experience in Information Technology.

At least 2 years of experience in ETL development using AbInitio
Strong understanding of Data warehouse principles along with ETL and Reporting skills
hands-on development experience with various Ab Initio components such as Rollup, Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, etc.
Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using Ab Initio.
Experience with SQL database programming, SQL performance tuning, relational model analysis.
Good knowledge in developing UNIX scripts, Oracle SQL/PL-SQL.
Manage team, perform code reviews, analyze execution plans, and re-factor inefficient code
Work closely with business and technology team to understand the requirements and design an optimal BI DWH architecture
Support team and end-users as a Subject Matter Expert (SME) through troubleshooting, recommendation of solutions and identifying opportunities to solve business problems through advanced Data Management and Data Quality solutions
Stay informed about the latest industry tools and concepts in DWH domain and determine applicability of emerging technologies/ trends to customer''s road map
Responsible for the quality assurance of all architecture and design deliverables. Manage and monitor the program activities from development phase to deployment for solution integration, testing and deployment.
Provide input, monitor and coordinate the project solution team across infrastructure, technical and functional work streams.
Provide oversight and technical guidance for developers on Ab Initio.