Syntricate Technologies

ODI Production Support Analyst

Syntricate Technologies$85K — $110K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in data warehouse (DWH) support using ODI.
  • Proficient in developing ETL processes including control tables and error management.
  • Skilled in implementing workflow design and parameterization.
  • Knowledgeable in ODI Master and work repository configurations.
  • Experience with setting up topology and building data objects in ODI.
  • Hands-on experience with customizing Knowledge Modules (KMs) in ODI.
  • Expert in performance tuning of ETL mappings and SQL.

Responsibilities

  • Provide DWH support and develop ETL processes using ODI.
  • Implement error logging and auditing for data processes.
  • Design and develop complex ETL mappings and process flows.
  • Create and manage Load Plans and job schedules in ODI.
  • Integrate various data sources and targets using ODI.
  • Develop data quality and reconciliation frameworks for ETL processes.
  • Tune SQL queries for optimal performance and maintain data integrity.

Benefits

  • Flexible work hours and potential for remote work.
  • Opportunities for professional development and training.
  • Collaborative team environment with advanced technology resources.
  • Health and wellness benefits including medical insurance.
  • Access to cutting-edge tools and technologies in data management.
Full Job Description
Required Skills: 6+ Year experience
  • 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

About Syntricate Technologies

Syntricate Technologies Careers

Joining Syntricate Technologies presents an unparalleled opportunity to advance a career in technology with a company at the forefront of digital innovation. Syntricate Technologies is renowned for its commitment to leadership, diversity, and leveraging technology to solve complex problems. This is where professionals come to not just seek job opportunities but to forge lasting careers in an environment that values growth and leadership.

Explore Career Opportunities

Syntricate Technologies is actively hiring and offers a variety of positions that cater to different skills and career aspirations. From entry-level roles to leadership positions, the potential for professional advancement is nearly limitless. Syntricate Technologies is not just a company; it's a place where talented individuals can thrive.

Innovation and Professional Growth

At Syntricate Technologies, innovation isn't just another buzzword—it's the cornerstone of the company culture. Employees are encouraged to push the boundaries of what is possible, bringing groundbreaking solutions to the table. With a team of dedicated professionals, Syntricate Technologies fosters a culture of continuous improvement and professional growth.

Diversity and Inclusion

Syntricate Technologies believes that diversity fuels innovation. With a commitment to creating a diverse and inclusive workplace, the company actively seeks to hire individuals from various backgrounds and experiences. Diversity training is integral, ensuring that all team members feel valued and understood.

Internship Programs and Employment Benefits

For those starting their careers, Syntricate Technologies offers robust internship programs that provide real-world experience and networking opportunities. Interns at Syntricate Technologies gain invaluable industry insights and professional skills that are crucial for future employment. Full-time employees enjoy a comprehensive benefits package that supports both their professional and personal lives. Benefits at Syntricate Technologies are designed to ensure employees are healthy, happy, and secure.

Applying for a Position

To apply for a position at Syntricate Technologies, candidates should prepare a resume that highlights relevant experience and skills. The interview process is designed to assess not only professional qualifications but also a candidate's fit within the company culture. Syntricate Technologies values curiosity, creativity, and a passion for technology.

Stay Connected with Syntricate Technologies Careers

Interested candidates are encouraged to explore the various job opportunities on the Syntricate Technologies careers page. Stay updated with the latest company news, employment trends, and career tips by subscribing to the Syntricate Technologies careers newsletter.

Join Syntricate Technologies

Discover the career possibilities that await at Syntricate Technologies. Search open positions that match your skills and interests. Syntricate Technologies is looking for passionate, driven, and innovative team players ready to contribute to a leading technology company.

SEARCH SYNTRICATE TECHNOLOGIES JOBS

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work at Syntricate Technologies.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. See what exciting and rewarding opportunities await at Syntricate Technologies.
Learn more about Syntricate Technologies
Size
51 employees
Industry

Similar Jobs

More Jobs at Syntricate Technologies

More Information Technology Jobs

Find similar ODI Production Support Analyst jobs: