• US Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 5th Oct 2022

Principal Purpose of Position:

· Design, develop, document complex processes that consolidate and integrate data

· Follow and contribute to best practices for data integration workflows

· Understanding and Analysis of requirements at sufficient level of detail to allow ETL solution to be developed

· Development of ETL job flows according to company standards for naming, performance, restart ability and performance.

· Develop, maintain, and extend reusable data integration components, per design from senior ETL developers/architects.

· Perform development, testing and implementation of Oracle PL/SQL.

· Support testing and remediation of defects in newly-developed/modified ETL workflows

· Provide ongoing support in PRODUCTION, including monitoring and troubleshooting

· Performance tune and troubleshoot ETL processes under development and in production as necessary.

· Collaborate with the Data Architecture team to understand and implement load processes for reporting and analytic data structures (data warehouses and data marts)

· Work with the DBA team to tune and refactor ETL workflows to perform well with databases.

· Work with the Data Architects to augment ERD’s as changes are developed

· Collaborate and be approachable to the team.

· Provide timely project and task updates to all concerned parties

· Monitor production data integration jobs and correct failures in a timely manner

Relevant Work Experience:

· Minimum 5 years of work experience in data integration and/or data warehousing

· Must have significant experience using enterprise ETL tools, SAP Data Services is strongly preferred, if not, must be willing to learn this tool.

· Must have a strong command of SQL, ANSI SQL, and PL/SQL for ETL relating to data warehousing and integration.

· Must have a proven track record of developing well-structured, maintainable ETL solutions

· Experience querying and loading dimensional and relational data models in a data warehouse environment is required

· Strong analytical skills, able to effectively solve problems in a timely manner

Planning/Organizing/Managerial Knowledge: (Ranges from task-focused to integrating related functions, to broadly strategic integration)

· Must be skilled in loading and querying dimensional and relational data models in transactional and data warehouse environments.