ETL ODI Developer

3 weeks ago


Varanasi, Uttar Pradesh, India TEKNIKOZ Full time

Greetings from Teknikoz

Experience : 7+years

*Night Shift - 9PM IST to 6AM IST*

We are seeking a skilled and experienced Data Integration Specialist with over 7+ years of experience in designing and developing data solutions using Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in data modeling, ETL/ELT processes, and SQL, along with exposure to Python scripting for API-based data ingestion.

Key Responsibilities:

  • Design, develop, and maintain functions and stored procedures using Oracle Data Integrator (ODI).
  • Create and document data warehouse schemas, including fact and dimension tables, based on business requirements.
  • Develop and execute SQL scripts for table creation and collaborate with Database Administrators (DBAs) for deployment.
  • Analyze various data sources to identify relationships and align them with Business Requirements Documentation (BRD).
  • Design and implement Extract, Load, Transform (ELT) processes to load data from source systems into staging and target environments.
  • Validate and profile data using Structured Query Language (SQL) and other analytical tools to ensure data accuracy and completeness.
  • Apply best practices in data governance, including query optimization, metadata management, and data quality monitoring.
  • Demonstrate strong data modeling skills to support scalable and efficient data architecture.
  • Utilize Python to automate data collection from APIs, enhancing integration workflows and enabling real-time data ingestion.
  • Investigate and resolve data quality issues through detailed analysis and root cause identification.
  • Communicate effectively with stakeholders through strong written, verbal, and analytical skills.
  • Exhibit excellent problem-solving and research capabilities in a fast-paced, data-driven environment.

  • ETL Specialist

    2 days ago


    Varanasi, Uttar Pradesh, India beBeeEtl Full time ₹ 18,00,000 - ₹ 25,00,000

    ETL SpecialistWe are seeking a highly skilled ETL Specialist to develop and maintain ETL processes, reports, and database solutions using SSIS, SSRS, and SQL Server.This role requires strong technical expertise to deliver high-quality code, optimize performance, and collaborate with cross-functional teams in an Agile/Kanban environment.Design, develop, and...


  • Varanasi, Uttar Pradesh, India beBeeData Full time ₹ 1,50,00,000 - ₹ 2,00,00,000

    Are you an expert in data engineering and architecture looking to drive business growth through technological advancements? Our client is seeking a seasoned ETL Developer to join their team.Job OverviewThis is a full-time opportunity for a talented individual to design, develop, and test ETL architecture, transformation jobs, and workflow schedules. The...


  • Varanasi, Uttar Pradesh, India beBeeDataEngineer Full time ₹ 15,00,000 - ₹ 30,00,000

    We are seeking a skilled Senior Data Engineer to join our team in developing and maintaining complex ETL pipelines using FiveTran, DBT Cloud, and custom frameworks.Key Responsibilities:ETL Pipeline Development: Design, develop, and maintain efficient ETL pipelines to extract, transform, and load data from various sources into Snowflake.Client-Specific...


  • Varanasi, Uttar Pradesh, India beBeeTalented Full time ₹ 18,00,000 - ₹ 21,00,000

    Talend ETL DeveloperWe are seeking a seasoned professional with expertise in Talend Open Studio to take on the role of an ETL Developer for a contractual position. The ideal candidate will have hands-on experience in designing and optimizing complex data pipelines using TMC, as well as proficiency in Python scripting, automation, and integration with cloud...


  • Varanasi, Uttar Pradesh, India beBeeOracle Full time ₹ 2,00,00,000 - ₹ 2,50,00,000

    Financial Close and Consolidation ExpertImplement Oracle FCCS solutions, focusing on project leadership, solution design, and technical capabilities. Strong knowledge of financial consolidation and close processes is essential.Lead overall project and solution designGuide project teams and conduct business requirement gathering sessionsDesign and validate...


  • Varanasi, Uttar Pradesh, India beBeeETLDeveloper Full time ₹ 1,50,00,000 - ₹ 2,00,00,000

    Senior Data EngineerWe are seeking a talented and motivated individual to join our data engineering team as a Senior Data Engineer.About the RoleThis role involves designing, developing, and maintaining large-scale data pipelines using IBM DataStage (on Cloud Pak for Data), AWS Glue, and Snowflake. You will work closely with cross-functional teams to ensure...


  • Varanasi, Uttar Pradesh, India beBeeDatabase Full time ₹ 1,80,00,000 - ₹ 2,20,00,000

    Senior Database Developer OpportunityWe are seeking a skilled Senior Database Developer to enhance our database infrastructure. The ideal candidate will have a strong background in Microsoft-based Database Engineering Technologies and experience with Transact-SQL Development, Data Warehousing, and ETL processes.Design, develop, and maintain complex database...


  • Varanasi, Uttar Pradesh, India beBeeInformatica Full time ₹ 18,00,000 - ₹ 25,00,000

    Data Engineer PositionOur organization is looking for a highly skilled Data Engineer to design, develop, and deploy complex ETL solutions using Informatica IDMC. The ideal candidate will have a strong background in developing, documenting, testing, and maintaining ETL applications.Key Responsibilities:Design and implement efficient data pipelines that...


  • Varanasi, Uttar Pradesh, India beBeeDataEngineering Full time US$ 1,80,000 - US$ 2,50,000

    Our Senior Data Engineering team is seeking a seasoned professional to design and optimize data solutions. The ideal candidate will be instrumental in designing and maintaining scalable data pipelines using Snowflake, Matillion, and Python.The role requires deep expertise in ETL development, data modeling, and financial data domains, particularly within...


  • Varanasi, Uttar Pradesh, India beBeeData Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Summary:We are seeking a skilled Associate Quality Assurance Lead to join our team.The ideal candidate will have expertise in Snowflake, ETL, Data Warehousing (DWH), and Data Migration (DM) testing, as well as strong leadership qualities to guide junior engineers and deliver high-quality data solutions.About the Role:This role is responsible for leading...