• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 26th Aug 2022

Need a senior ETL engineer. The incumbent analyzes designs, develops, documents, and implements new software applications and maintains and supports existing applications
to provide information technology solutions for the corporation.  The incumbent coordinates
and leads all size projects including large-scale projects requiring multiple systems resources. 
The incumbent serves as a resource and mentor for other IT and business associates. 
This position serves in a team utilizing the IBM InfoSphere suite of tools, primarily DataStage,
to develop ETL jobs in building an Enterprise Data Warehouse for the company.

Superior knowledge of and experience using programming languages, platforms, and data structure
•             Excellent analytical thinking skills with experience in identifying, scrutinizing, improving, and streamlining complex work processes
•             Superior knowledge of and experience applying application software development methodologies
•             Excellent research, decision-making and judgment skills
•             Experience in a position problem solving and working independently
•             Experience in a position communicating with all levels of associates and managers
•             Experience in a position requiring technical writing, editing, and proofreading
•             Experience effectively prioritizing and juggling multiple concurrent projects
•             Experience motivating, mobilizing, and coaching associates/peers
•             Experience relating to others, inspiring others to participate, and mitigating conflict
•             In depth knowledge of Structured Query Language (SQL)
•             Excellent DB2/Z/OS knowledge, including table structure and relationships, and load utilities
•             Experience leading agile development teams is preferred
•             Training or experience with ETL development is preferred
•             Knowledge or experience with Data Warehouse concepts is preferred
•             Knowledge or experience in healthcare industry is preferred
•             Design and develop applications using IBM InfoSphere DataStage (Designer, Director, and Administrator) [v11.x] and Quality Stage [v11.x].
•             Develop ETL code to load the Enterprise Data Warehouses using relational databases (DB2 Z/OS and MS SQL Server) applying transformations and business rules as defined in requirements.
•             Integrate data from multiple sources (MQ, IBM Mainframe Z/OS, XML, flat files, unstructured data, DB2 Z/OS, MS SQL Server, etc.) to staging tables. 
•             Load dimension and fact tables.