Us Citizen
Green Card
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 18th Nov 2020
Job Title Lead ETL Developer
Location Remote OH
Duration 3 months /Contract To Hire
JOB DESCRIPTION
Interview Mode- Phone and Skype
REMOTE till covid
Description:
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Design, Code, Test, and Document mappings/transformations of load routines to the Data Warehouse or Data Marts.
Translation of Functional Specifications into Technical Design Specifications for off-shore development team.
May serve as an individual contributor on smaller initiatives, or as a member of a development team on larger initiatives.
Function as Technical Lead to junior resources or our off-shore development team.
May be asked to tune SQL statements to ensure optimal performance.
Provide input on physical database design decisions.
Trouble shoot and problem solve data integrity issues.
Maintain documentation in corporate data dictionary.
May provide 24 x 7 production support.
MINIMUM KNOWLEDGE, SKILLS AND ABILITES REQUIRED:
3 - 5 years of related experience.
Proficient in SQL.
General understanding of Data Modeling principles.
General knowledge of Extract, Transform, and Load (ETL) concepts, and working knowledge of 3rd party ETL tool.
Knowledge of DataStage and/or Job Control Language (JCL) a plus.
Scripting skills (SQL, AQT, Shell) a plus.
TECHNICAL SKILLS
Must Have
Ascential DataStage
DataStage, SQL, understanding of dimensionally-designed databases, and experience interacting with a relational database (DB2, Oracle, etc.). Mainframe experience would be a bonus, but not required. Ability to analyze complex data flows and understand existing jobs.
DB2
Nice To Have
Basic IBM Mainframe COBOL and JCL Skills
Neha Pandey
(Technical Resource Specialist)
InTime Infotech Inctime matters39962 Cedar Blvd., Ste 185, Newark CA 94560Contact# : 302-401-6677 x 327Direct : 302-401-6725Fax : 510-201-2367