Description
As an ODI Specialist, you will work with technical teams and projects to deliver ETL solutions on-premises and Oracle cloud platforms for some of our Fortune 1000 clients. You will have the opportunity to contribute to work that may involve building new ETL solutions, migrating an application to co-exist in the hybrid cloud (On-Premises and Cloud). Our teams have a diverse range of skills and we are always looking for new ways to innovate and help our clients succeed.
Work You’ll Do
As an ODI developer you will have multiple responsibilities depending on project type. One type of project may involve migrating existing ETL to Oracle cloud infrastructure. Another type of project might involve building ETL solution on both on-premises and Oracle Cloud.
The key responsibilities may involve some or all the areas listed below:
• Engage with clients to
• Conduct workshops, understand business requirements and identify business problems to solve with integrations.
• Lead and build Proof-of-concept to showcase value of ODI vs other platforms
• socialize solution design and enable knowledge transfer
• drive train-the trainer sessions to drive adoption of ODI
• partner with clients to drive outcome and deliver value
• Collaborate with cross functional teams to
• understand source applications and how it can be integrated
• analyze data sets to understand functional and business context
• create Data Warehousing data model and integration design
• understand cross functional process such as Record to Report (RTR), Procure to Pay (PTP), Order to Cash (OTC), Acquire to Retire (ATR), Project to Complete (PTC)
• communicate development status and risks to key stakeholders
• Lead the team to design, build, test and deploy
• Support client needs by delivering ODI jobs and frameworks
• Merge, Customize and Deploy ODI data model as per client business requirements
• Deliver large/medium DWH programs, demonstrate expert core consulting skills and advanced level of ODI, SQL, PL/SQL knowledge and industry expertise to support delivery to clients
• Focus on designing, building, and documenting re-usable code artifacts
• Track, report and optimize ODI jobs performance to meet client SLA
• Designing and architecting ODI projects including upgrade/migrations to cloud
• Design and implement security in ODI
• Identify risks and suggest mitigation plan
• Ability to lead the team and mentor junior practitioners
• Produce high-quality code resulting from knowledge of the tool, code peer review, and automated unit test scripts
• Perform system analysis, follow technical design and work on development activities
• Participate in design meetings, daily standups, backlog grooming
• Lead respective tracks in Scrum team meetings, including all Agile and Scrum related activities
• Reviews and evaluates designs and project activities for compliance with systems design and development guidelines and standards; provides tangible feedback to improve product quality and mitigate failure risk.
• Develop environment strategy, Build the environment & execute migration plans
• Validate the environment to meets all security and compliance controls
• Lead the testing efforts during SIT and UAT by coordinating with functional teams and all stakeholders
• Contribute to sales pursuits by helping the pursuit team to understand the client request and propose robust solutions
Ideally, you should also have
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
• Working knowledge of GIT or similar source code control system
• Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
Analytics & Cognitive
Our Analytics & Cognitive team focuses on enabling our client’s end-to-end journey from On-Premise to Cloud, with opportunities in the areas of: Cloud Strategy, Op Model Transformation, Cloud Development, Cloud Integration & APIs, Cloud Migration, Cloud Infrastructure & Engineering, and Cloud Managed Services. We help our clients see the transformational capabilities of Cloud as an opportunity for business enablement and competitive advantage.
Analytics & Cognitive team supports our clients as they improve agility and resilience, and identifies opportunities to reduce IT operations spend through automation by enabling Cloud. We accelerate our clients towards a technology-driven future, leveraging vendor solutions and Deloitte-developed software products, tools, and accelerators.
Technical Requirements
• Education: B.E./B.Tech/M.C.A./M.Sc (CS)
• 6+ years ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI)
• Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
• Minimum 2-3 end to end DWH Implementation experience.
• Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.
• knowledge of ODI Master and work repository
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.
• Packaging components, database operations like Aggregate pivot, union 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
• Integrate ODI with multiple Source / Target
• Experience in Data Migration using SQL loader, import/export
Consulting Requirements
• 6-10 years of relevant consulting, industry or technology experience
• Proven experience assessing client’s workloads and technology landscape for Cloud suitability
• Experience in defining new architectures and ability to drive project from architecture standpoint
• Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization.
• Strong problem solving and troubleshooting skills
• Strong communicator
• Willingness to travel in case of project requirement
Preferred
• Experience in Oracle BI Apps
• Exposure to one or more of the following: Python, R or UNIX shell scripting.
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
• Working knowledge of GIT or similar source code control system
• Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents
• Systematic problem-solving approach, coupled with strong communication skills
• Ability to debug and optimize code and automate routine tasks.
• Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar.
• Experience working with technical customers
Responsibilities
Description
As an ODI Specialist, you will work with technical teams and projects to deliver ETL solutions on-premises and Oracle cloud platforms for some of our Fortune 1000 clients. You will have the opportunity to contribute to work that may involve building new ETL solutions, migrating an application to co-exist in the hybrid cloud (On-Premises and Cloud). Our teams have a diverse range of skills and we are always looking for new ways to innovate and help our clients succeed.
Work You’ll Do
As an ODI developer you will have multiple responsibilities depending on project type. One type of project may involve migrating existing ETL to Oracle cloud infrastructure. Another type of project might involve building ETL solution on both on-premises and Oracle Cloud.
The key responsibilities may involve some or all the areas listed below:
• Engage with clients to
• Conduct workshops, understand business requirements and identify business problems to solve with integrations.
• Lead and build Proof-of-concept to showcase value of ODI vs other platforms
• socialize solution design and enable knowledge transfer
• drive train-the trainer sessions to drive adoption of ODI
• partner with clients to drive outcome and deliver value
• Collaborate with cross functional teams to
• understand source applications and how it can be integrated
• analyze data sets to understand functional and business context
• create Data Warehousing data model and integration design
• understand cross functional process such as Record to Report (RTR), Procure to Pay (PTP), Order to Cash (OTC), Acquire to Retire (ATR), Project to Complete (PTC)
• communicate development status and risks to key stakeholders
• Lead the team to design, build, test and deploy
• Support client needs by delivering ODI jobs and frameworks
• Merge, Customize and Deploy ODI data model as per client business requirements
• Deliver large/medium DWH programs, demonstrate expert core consulting skills and advanced level of ODI, SQL, PL/SQL knowledge and industry expertise to support delivery to clients
• Focus on designing, building, and documenting re-usable code artifacts
• Track, report and optimize ODI jobs performance to meet client SLA
• Designing and architecting ODI projects including upgrade/migrations to cloud
• Design and implement security in ODI
• Identify risks and suggest mitigation plan
• Ability to lead the team and mentor junior practitioners
• Produce high-quality code resulting from knowledge of the tool, code peer review, and automated unit test scripts
• Perform system analysis, follow technical design and work on development activities
• Participate in design meetings, daily standups, backlog grooming
• Lead respective tracks in Scrum team meetings, including all Agile and Scrum related activities
• Reviews and evaluates designs and project activities for compliance with systems design and development guidelines and standards; provides tangible feedback to improve product quality and mitigate failure risk.
• Develop environment strategy, Build the environment & execute migration plans
• Validate the environment to meets all security and compliance controls
• Lead the testing efforts during SIT and UAT by coordinating with functional teams and all stakeholders
• Contribute to sales pursuits by helping the pursuit team to understand the client request and propose robust solutions
Ideally, you should also have
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
• Working knowledge of GIT or similar source code control system
• Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
Analytics & Cognitive
Our Analytics & Cognitive team focuses on enabling our client’s end-to-end journey from On-Premise to Cloud, with opportunities in the areas of: Cloud Strategy, Op Model Transformation, Cloud Development, Cloud Integration & APIs, Cloud Migration, Cloud Infrastructure & Engineering, and Cloud Managed Services. We help our clients see the transformational capabilities of Cloud as an opportunity for business enablement and competitive advantage.
Analytics & Cognitive team supports our clients as they improve agility and resilience, and identifies opportunities to reduce IT operations spend through automation by enabling Cloud. We accelerate our clients towards a technology-driven future, leveraging vendor solutions and Deloitte-developed software products, tools, and accelerators.
Technical Requirements
• Education: B.E./B.Tech/M.C.A./M.Sc (CS)
• 6+ years ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI)
• Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
• Minimum 2-3 end to end DWH Implementation experience.
• Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.
• knowledge of ODI Master and work repository
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.
• Packaging components, database operations like Aggregate pivot, union 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
• Integrate ODI with multiple Source / Target
• Experience in Data Migration using SQL loader, import/export
Consulting Requirements
• 6-10 years of relevant consulting, industry or technology experience
• Proven experience assessing client’s workloads and technology landscape for Cloud suitability
• Experience in defining new architectures and ability to drive project from architecture standpoint
• Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization.
• Strong problem solving and troubleshooting skills
• Strong communicator
• Willingness to travel in case of project requirement
Preferred
• Experience in Oracle BI Apps
• Exposure to one or more of the following: Python, R or UNIX shell scripting.
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
• Working knowledge of GIT or similar source code control system
• Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents
• Systematic problem-solving approach, coupled with strong communication skills
• Ability to debug and optimize code and automate routine tasks.
• Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar.
• Experience working with technical customers
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Key Responsibilities
• Project Leadership:
o Lead Appian development and implementation projects from inception to deployment.
o Coordinate with business analysts, architects, and QA teams to ensure timely delivery.
• Solution Design & Development:
o Design Appian applications including process models, SAIL interfaces, records, reports, and sites.
o Implement integrations with external systems using REST/SOAP APIs and Appian smart services.
• Implementation & Deployment:
o Manage configuration, environment setup, and deployment activities.
o Ensure adherence to Appian best practices and performance optimization.
• Team Management:
o Mentor and guide Appian developers, conduct code reviews, and enforce quality standards.
• Stakeholder Engagement:
o Collaborate with clients and internal teams to gather requirements and provide technical solutions.
Required Skills
• Strong hands-on experience in Appian BPM (SAIL, Process Models, Rules, Records, Sites).
• Expertise in Appian plug-ins, smart services, and Appian Administration.
• Proficiency in integration technologies (REST/SOAP APIs, Web Services).
• Good understanding of relational databases and SQL.
Nice-to-Have
• Knowledge of Java or other backend technologies.
• Experience in Agile methodology and CI/CD pipelines.
• Familiarity with cloud platforms (AWS, Azure).
Responsibilities
Key Responsibilities
• Project Leadership:
o Lead Appian development and implementation projects from inception to deployment.
o Coordinate with business analysts, architects, and QA teams to ensure timely delivery.
• Solution Design & Development:
o Design Appian applications including process models, SAIL interfaces, records, reports, and sites.
o Implement integrations with external systems using REST/SOAP APIs and Appian smart services.
• Implementation & Deployment:
o Manage configuration, environment setup, and deployment activities.
o Ensure adherence to Appian best practices and performance optimization.
• Team Management:
o Mentor and guide Appian developers, conduct code reviews, and enforce quality standards.
• Stakeholder Engagement:
o Collaborate with clients and internal teams to gather requirements and provide technical solutions.
Required Skills
• Strong hands-on experience in Appian BPM (SAIL, Process Models, Rules, Records, Sites).
• Expertise in Appian plug-ins, smart services, and Appian Administration.
• Proficiency in integration technologies (REST/SOAP APIs, Web Services).
• Good understanding of relational databases and SQL.
Nice-to-Have
• Knowledge of Java or other backend technologies.
• Experience in Agile methodology and CI/CD pipelines.
• Familiarity with cloud platforms (AWS, Azure).
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Role Category :Programming & Design
Role : 546821 - Appian Lead - Blr, Hyd, Che - EAIS
Digital: Mongo DB (.Net+Mong0/Neo4j Developer)
Must-Have**
1. C# and .Net Framework
2. Window Service
3. Expert Object-Oriented Programing skills
4. Mongo / Nosql DB OR Neo4j/Graph DB
Responsibilities
Must-Have**
1. C# and .Net Framework
2. Window Service
3. Expert Object-Oriented Programing skills
4. Mongo / Nosql DB OR Neo4j/Graph DB
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Role Category :Programming & Design
Role :Digital: Mongo DB (.Net+Mong0/Neo4j Developer)
Automation Testing~Automated QA - TestComplete
Design and develop automated test scripts for web| mobile| and API applications.
Create and maintain test automation frameworks using industry-standard tools.
Execute automated test suites and analyze results- Integrate automated tests into CICD pipelines (Jenkins| GitLab| Azure DevOps)
Identify| document| and track defects through resolution
Collaborate with developers| QA| and product teams
Perform functional| regression| integration| and performance testing
Maintain test documentation and report on quality metrics
Responsibilities
Design and develop automated test scripts for web| mobile| and API applications.
Create and maintain test automation frameworks using industry-standard tools.
Execute automated test suites and analyze results- Integrate automated tests into CICD pipelines (Jenkins| GitLab| Azure DevOps)
Identify| document| and track defects through resolution
Collaborate with developers| QA| and product teams
Perform functional| regression| integration| and performance testing
Maintain test documentation and report on quality metrics
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Role Category :Programming & Design
Role :Automation Testing~Automated QA - TestComplete
• 5+ years of IT experience with at least 4+ years in Camunda BPM architecture/solutioning.
• Strong expertise in:
o BPMN 2.0
o DMN
o Java, Spring Boot
o Microservices architecture
o Event driven architecture (Kafka preferred)
• Experience with Camunda 7 and/or Camunda 8 (Zeebe).
• Hands on with REST APIs, JSON, and integration patterns.
• Knowledge of Kubernetes, Docker, cloud platforms (AWS/Azure/GCP).
• Familiarity with monitoring tools (Grafana, Prometheus, Elastic, Operate/Zeebe tools).
Soft Skills
• Strong problem solving and analytical thinking.
• Excellent communication and documentation skills.
• Ability to drive architecture decisions and influence stakeholders.
• Ability to lead cross functional teams and deliver large enterprise solutions.
Responsibilities
• 5+ years of IT experience with at least 4+ years in Camunda BPM architecture/solutioning.
• Strong expertise in:
o BPMN 2.0
o DMN
o Java, Spring Boot
o Microservices architecture
o Event driven architecture (Kafka preferred)
• Experience with Camunda 7 and/or Camunda 8 (Zeebe).
• Hands on with REST APIs, JSON, and integration patterns.
• Knowledge of Kubernetes, Docker, cloud platforms (AWS/Azure/GCP).
• Familiarity with monitoring tools (Grafana, Prometheus, Elastic, Operate/Zeebe tools).
Soft Skills
• Strong problem solving and analytical thinking.
• Excellent communication and documentation skills.
• Ability to drive architecture decisions and influence stakeholders.
• Ability to lead cross functional teams and deliver large enterprise solutions.
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Informatica CDI (Cloud Data Integration)
Must Have Technical/Functional Skills
· 3–6 years of experience in ETL development and data integration.
· Hands-on experience with Matillion (preferred) or strong expertise in Ab Initio, Informatica,
or DataStage
· Strong SQL skills and experience with relational databases (Oracle, SQL Server, etc.).
· Knowledge of data warehousing concepts and dimensional modeling.
· Experience with scheduling tools and job monitoring.
· Familiarity with cloud platforms (AWS, Azure, or GCP) is a plus.
· Strong problem-solving and analytical skills.
· Experience with scripting languages (Python, Shell) and Knowledge of big data technologies
Responsibilities
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
: Databricks, AWS, Python, API Integration, ETL/ELT
Design, build, and maintain scalable data pipelines using Python and Apache Spark (via Databricks).
• Develop ETL/ELT workflows to ingest, transform, and load structured and unstructured data from various sources.
• Optimize data workflows for performance, reliability, and scalability in cloud environments.
• Work with Databricks to develop notebooks, jobs, and workflows for data processing and analytics.
• Collaborate with data scientists, analysts, and other engineering teams to deliver high-quality data solutions.
• Implement data quality checks, monitoring, and alerting mechanisms.
• Integrate data solutions with AWS services such as S3, Glue, Lambda, DynamoDB, and API Gateway.
• Ensure compliance with data governance and security standards, including HIPAA and other healthcare regulations.
• Participate in code reviews, architectural discussions, and contribute to technical strategy.
Responsibilities
Design, build, and maintain scalable data pipelines using Python and Apache Spark (via Databricks).
• Develop ETL/ELT workflows to ingest, transform, and load structured and unstructured data from various sources.
• Optimize data workflows for performance, reliability, and scalability in cloud environments.
• Work with Databricks to develop notebooks, jobs, and workflows for data processing and analytics.
• Collaborate with data scientists, analysts, and other engineering teams to deliver high-quality data solutions.
• Implement data quality checks, monitoring, and alerting mechanisms.
• Integrate data solutions with AWS services such as S3, Glue, Lambda, DynamoDB, and API Gateway.
• Ensure compliance with data governance and security standards, including HIPAA and other healthcare regulations.
• Participate in code reviews, architectural discussions, and contribute to technical strategy.
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Role Category :Programming & Design
Role :: Databricks, AWS, Python, API Integration, ETL/ELT
AWS, Python, API Integration, ETL/ELT
Job Description: Data Engineer : -
• Design, build, and maintain scalable data pipelines using Python and Apache Spark (via Databricks).
• Develop ETL/ELT workflows to ingest, transform, and load structured and unstructured data from various sources.
• Optimize data workflows for performance, reliability, and scalability in cloud environments.
• Work with Databricks to develop notebooks, jobs, and workflows for data processing and analytics.
• Collaborate with data scientists, analysts, and other engineering teams to deliver high-quality data solutions.
• Implement data quality checks, monitoring, and alerting mechanisms.
• Integrate data solutions with AWS services such as S3, Glue, Lambda, DynamoDB, and API Gateway.
• Ensure compliance with data governance and security standards, including HIPAA and other healthcare regulations.
• Participate in code reviews, architectural discussions, and contribute to technical strategy.
Responsibilities
Job Description: Data Engineer : -
• Design, build, and maintain scalable data pipelines using Python and Apache Spark (via Databricks).
• Develop ETL/ELT workflows to ingest, transform, and load structured and unstructured data from various sources.
• Optimize data workflows for performance, reliability, and scalability in cloud environments.
• Work with Databricks to develop notebooks, jobs, and workflows for data processing and analytics.
• Collaborate with data scientists, analysts, and other engineering teams to deliver high-quality data solutions.
• Implement data quality checks, monitoring, and alerting mechanisms.
• Integrate data solutions with AWS services such as S3, Glue, Lambda, DynamoDB, and API Gateway.
• Ensure compliance with data governance and security standards, including HIPAA and other healthcare regulations.
• Participate in code reviews, architectural discussions, and contribute to technical strategy.
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
