What are the responsibilities and job description for the ODI Developer/Production Support analyst position at ApTask?
About Client :
The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong emphasis on employee training and development. Client is known for its commitment to innovation and invests in research and development to stay at the forefront of technological advancements.
It offers a comprehensive set of services, including :
IT Services : Application development, maintenance, and testing.
Consulting : Business consulting, IT strategy, and digital transformation.
Business Process Outsourcing (BPO) : Outsourcing of business processes to improve efficiency.
Enterprise Solutions : Implementation and support of enterprise-level software solutions. Digital Services : Services related to digital technologies, such as analytics, cloud, and IoT.
Salary Range : $110K-$120K / Annum
Location : Bloomfield, CT / Philadelphia, PA / Austin, TX / Bloomfield, CT / Austin , TX / Plano, TX / Tampa, FL / Raleigh, NC / Chattanooga, TN / Sunrise, FL / Minneapolis, MN / New York, NY / Phoenix city, AZ
Job Description :
Technical / Functional Skills
- DWH support experience using ODI.
- Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc. Should be able to implement reusability, parameterization, workflow design, etc.
- knowledge of ODI Master and work repository
- Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
- using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
- Design and develop complex mappings, Process Flows and ETL scripts
- Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
- Experience of performance tuning of mappings
- Ability to design ETL unit test cases and debug ETL Mappings
- Expertise in developing Load Plans, Scheduling Jobs
- Ability to design data quality and reconciliation framework using ODI
- Integrate ODI with multiple Source / Target
- Experience on Error recycling / management using ODI,PL / SQL
- Expertise in database development (SQL / PLSQL) for PL / SQL based applications.
- Experience in SQL tuning and optimization using explain plan and Sql trace files.
- Strong knowledge of ELT / ETL concepts, design and coding
- Partitioning and Indexing strategy for optimal performance
Experience Required :
About ApTask :
ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer :
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com.
Salary : $110,000 - $120,000
