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 :- 25th Aug 2022
The ETL Data Engineer is responsible for supporting the Cox Enterprises Data Platforms & Services team through the lifecycle of multiple large-scale data engineering projects for the company’s Human Capital Management (HCM) portfolio. This role will drive a solution-based approach for the development of standardized Informatica Power Center solutions for the enterprise. This role will help build and enforce ETL and Data Warehousing standards, guidelines, and processes to support the Business Intelligence Reporting and Analytics needs for the company’s HCM reporting function. The ETL Data Engineer will partner closely with Project Managers, Enterprise Architects, and Business Users to deliver solutions in support of the reporting and analysis needs for the HCM portfolio.
Top 5 Must Haves:
o Informatica PowerCenter
o Informatica Developer
o Analytical SQL functions and PL SQL/SQL expertise
o Python, JavaScript, UNIX shell scripting
o Data modeling
Core Technology Requirements:
· Informatica Power Center (five years) with recent hands-on experience with:
o Informatica PowerCenter
o Informatica Developer
o Informatica Data Management Cloud (IDMC)
o Analytical SQL functions and PL SQL/SQL expertise (five years) of recent hands-on experience as an individual contributor
o Oracle Application Express (APEX)
o Python, JavaScript, UNIX shell scripting
o Data modeling
Required Qualifications:
· Bachelor's degree in Computer Science, Engineering, or related discipline
· Minimum five years IT experience
· Minimum five years supporting ETL implementations using Informatica Power Center and IDQ
· Knowledge of Peoplesoft and Workday HCM data subject areas, preferred
· Data Warehousing: Kimball methodology (five years)
· Minimum five years of experience in a complex Enterprise Data Warehouse/Business Intelligence development environment
· Understanding of Agile Software Development methodology
· Experience in application design and implementation, distributed architecture and concepts, data manipulation and analysis using PL/SQL and SQL
· Experience in developing code, test plans, expected results, and test data at a program level
· Proven analytical and technical problem-solving skills
· Proven track record of deploying large scale ETL/Data Warehouse/Business Intelligence systems
· Demonstrated technical leadership in an IT organization
· Possess strong architectural leadership skills, and have a demonstrated ability to produce results in a large application environment
· Excellent verbal and written communication skills for interaction with business users, solution owners, and development team members
· Extensive technical knowledge of Business Solutions & ETL Architecture/Design
· Experience with relevant office software, including Microsoft Office applications, MS Project, Visio, and MS PowerPoint
· Solution-minded
· ERP/Business Intelligence systems background