1035 Indexes Jobs - Page 21

Country India Working Schedule Full-Time Work Arrangement Hybrid Relocation Assistance Available No Posted Date 23-Jun-2025 Job ID 10081 Description And Requirements Job Responsibilities Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex Oracle databases from version 11g to 19c (CDB/PDB and Standalone) on (Linux/AIX) Operating System. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance; Makes use of advanced database features such as partitioning, advanced compression, multitenant architecture, etc. Participates in the design, implementation and maintenance of automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform. Participates in the develop and management of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic. Identifies and resolves problem utilizing structured tools and techniques. Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Participate in basic Root Cause Analysis (RCA) Maintains, and administers data infrastructure security policies safeguarding information, evaluating existing data infrastructure security procedures and identifying new areas of risk. working knowledge of ServiceNow ticketing system, KB article creation and maintenance, and CMDB maintenance 4+ years of experience with Performance Tuning, physical database design, database programming skills, and shell scripting Working experience with Cloud infrastructure, Elastic, Ansible, data replication and project management Education, Technical Skills & Other Critical Requirement Education Bachelor’s degree in computer science, Information Systems, or another related field with 7+ years of IT and Infrastructure engineering work experience. Experience (In Years) 7+ Years Total IT experience & 4+ Years relevant experience in Oracle database Technical Skills 4+ years of related work experience with application database implementation; knowledge of all key Oracle utilities such as SQLPLUS, RMAN, OEM, Data Pump, Active Data Guard and OID. 2+ years Unix and Linux operating systems and 1 year’s shell scripting. Strong database analytical skills to improve application performance. Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and integrity constraints Engineering and support experience with PeopleSoft financials application databases and Goldengate replications. Extensive experience in Backup and recovery (Data pump, RMAN, Rubrik). Good knowledge in performance tuning with hands on experience on AWR, ADDM, SQLTRPT skill. Experience in Data guard configuration (DR). Experience in Database switchover and failover. Working knowledge in Cloud computing (Azure, OCI) Data security by managing roles and privileges to User and groups. Experience in installation and configuration of OEM Agent and monitoring. Experience in working Ticketing tools (ServiceNow) Understanding of modern IT infrastructure such as Cloud Architecture as well as Agile DevOps Framework. Other Critical Requirements Automation tools and programming such as Python and Ansible. Monitoring the database using Elastic and Oracle Enterprise monitoring (OEM) OCA or OCP 19c and above certification preferable Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Prior experience in handling state side and offshore stakeholders Experience in creating and delivering Business presentations. Demonstrate ability to work independently and in a team environment Ability to work 24*7 rotational shift to support for production, development, and test databases About MetLife Recognized on Fortune magazine's list of the 2025 "World's Most Admired Companies" and Fortune World’s 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we’re inspired to transform the next century in financial services. At MetLife, it’s #AllTogetherPossible. Join us!

Position: SQL Developer Trainee Company: Lead India Location: Remote Job Type: Internship (Full-Time) Duration: 1–3 Months Stipend: ₹25,000/month Start Date: Immediate About Lead India Lead India is dedicated to empowering the next generation of professionals through hands-on learning and impactful projects. We focus on innovation, technology, and leadership development to prepare individuals for real-world challenges. Role Overview We are looking for an enthusiastic SQL Developer Trainee to join our team. This internship is an excellent opportunity to gain practical experience in database development, data querying, and backend data operations in a real-world business environment. Key Responsibilities Write and optimize SQL queries for data extraction, transformation, and reporting. Design and manage relational databases, including creating tables, views, indexes, and stored procedures. Support data integration and migration tasks. Troubleshoot and resolve database-related issues. Collaborate with developers and analysts to understand data requirements. Maintain documentation of database structures and processes. Requirements Pursuing or recently completed a degree in Computer Science, Information Technology, or a related field. Basic understanding of SQL and relational database concepts (e.g., MySQL, PostgreSQL, SQL Server). Familiarity with writing simple queries, joins, and data manipulation statements. Strong analytical and problem-solving skills. Willingness to learn and work independently in a remote environment. Good communication and documentation skills. Benefits Hands-on experience with real-world data and database systems. Opportunity to work under the mentorship of experienced developers. Certificate of Internship upon successful completion. Possibility of a full-time offer based on performance.

Current JD – Data Quality Engineer (Role). Ready to work as DQE. 1. ETL Testing Experience , Experience in Python /Java programming required to automate data analysis tasks - Must have 2. Experience in writing Advance SQL queries (Topics listed below) - Must have 3. Knowledge of BDD and Cucumber - Good to have 4. Knowledge of Agile methodologies, CI/CD etc. - Good to have 5. Hands on Functional Data / ETL Testing Experience - Good to have Advanced SQL topics delve into more complex database operations and query optimization techniques. Here are some key areas to explore: Window Functions RANK, DENSE_RANK, ROW_NUMBER: Assign a rank to each row within a partition. LEAD, LAG: Access rows preceding or following the current row within a partition. PARTITION BY, ORDER BY: Define partitions and the order within each partition. Window frames: Specify the range of rows included in a window function calculation. Common Table Expressions (CTEs) Recursive CTEs: Create recursive queries to process hierarchical data. Multiple CTEs: Use multiple CTEs to break down complex queries into smaller, more manageable parts. Subqueries Correlated subqueries: Subqueries that reference columns from the outer query. Scalar subqueries: Subqueries that return a single value. EXISTS and NOT EXISTS: Test for the existence or non-existence of rows in a subquery. Analytical Functions CUME_DIST: Calculate the cumulative distribution of a value within a group. PERCENT_RANK: Calculate the percentile rank of a value within a group. NTILE: Divide a result set into a specified number of groups. Full-Text Search Full-text indexes: Create indexes that support full-text search capabilities. Ranking functions: Rank search results based on relevance. Stop words: Exclude common words from search queries. Hierarchical Queries CONNECT BY PRIOR: Traverse hierarchical relationships in a table. START WITH: Specify the starting point for a hierarchical query. Optimization Techniques Indexes: Create appropriate indexes to improve query performance. Query tuning: Analyze query execution plans and optimize queries. Materialized views: Pre-calculate and store query results for faster access.

About the Company They balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what’s now to what’s next by unlocking the value of their data and applications to solve their digital challenges, achieving outcomes that benefit both business and society. About the Client Our client is a global digital solutions and technology consulting company headquartered in Mumbai, India. The company generates annual revenue of over $4.29 billion (₹35,517 crore), reflecting a 4.4% year-over-year growth in USD terms. It has a workforce of around 86,000 professionals operating in more than 40 countries and serves a global client base of over 700 organizations. Our client operates across several major industry sectors, including Banking, Financial Services & Insurance (BFSI), Technology, Media & Telecommunications (TMT), Healthcare & Life Sciences, and Manufacturing & Consumer. In the past year, the company achieved a net profit of $553.4 million (₹4,584.6 crore), marking a 1.4% increase from the previous year. It also recorded a strong order inflow of $5.6 billion, up 15.7% year-over-year, highlighting growing demand across its service lines. Key focus areas include Digital Transformation, Enterprise AI, Data & Analytics, and Product Engineering—reflecting its strategic commitment to driving innovation and value for clients across industries. Detailed JD : Minimum of 5 years of industry experience managing MySQL Perform MySql database administration on on premise or cloud Ensure best practises of database access and security Work closely with the Development teams to review the DB schema changes in every release cycle Monitor the DB performance for slow queries indexes and various other DB metrics Experience on Database migration and performance monitoring tools Experience working with databases like Postgresql Document DB etc is a bonus Ability to learn new technologies as required by the role Performed Installation new databases design configuration backup recovery security upgrade schema changes tuning and data integrity Performed incremental backup and log file rotation Increased database performance by utilizing MSSQL configuration changes multiple instances Creating and managing meaningful table indexes to improve performance Familiar with handson experience on different MSSQL cluster setups like Innodb Galeria Percona in both activeactive and activepassive configurations Hands on experience in Upgrading MSSQL Strong experience with SQL and PLSQL including solid troubleshooting SQL tuning skills Identify areas for improvement in SQL operations and implementations Extensive experience with the Extract Transform and Load phases of data intake as well as known best practise Experienced in platform support project and development projects

Greetings from TCS !!! TCS is conducting a Walk-in Drive on 28th June 2025 (Saturday) for Salesforce Developer at Chennai. Location- TCS CHENNAI, Taramani 100 Feet Road, 165/1A, New Colony Road, Velachery, Chennai, Tamil Nadu 600042 https://g.co/kgs/Lx9tNRM Role - Salesforce Developer Exp Range- 5 to 11yrs Job description: Expertise in Salesforce Development using Lightning Components, Apex Language, Visual Force pages, Classes, Controllers, Triggers, Indexes and Apex Web services. Hands on experience in Salesforce Lightning Components Development. Expertise in Salesforce Configurations using Work flows, Process builders, Flows, Roles, Enterprise Territory Management, Security Controls, Reports and Dashboards and Sharing rules.

Greetings from TCS !!! TCS is conducting a Walk-in Drive on 28th June 2025 (Saturday) for Salesforce Developer at HYDERABAD. Location- TCS HYDERABAD, Deccan Park, Plot No.1, Hitech City Main Rd, Software Units Layout, HUDA Techno Enclave, Madhapur, Hyderabad, Telangana 500081 . https://g.co/kgs/pEhLVUj Role - Salesforce Developer Exp Range- 5 to 11yrs Job description: Expertise in Salesforce Development using Lightning Components, Apex Language, Visual Force pages, Classes, Controllers, Triggers, Indexes and Apex Web services. Hands on experience in Salesforce Lightning Components Development. Expertise in Salesforce Configurations using Work flows, Process builders, Flows, Roles, Enterprise Territory Management, Security Controls, Reports and Dashboards and Sharing rules.

Who we are We're a leading, global security authority that's disrupting our own category. Our encryption is trusted by the major ecommerce brands, the world's largest companies, the major cloud providers, entire country financial systems, entire internets of things and even down to the little things like surgically embedded pacemakers. We help companies put trust - an abstract idea - to work. That's digital trust for the real world. Job summary The DigiCert ONE CA team is looking for a knowledgeable Senior Software Engineer to join our agile cross functional team to build the future of PKI and security management. What you will do Build RESTful, highly scalable cloud native webservices using Go Collaborate with the team in the design, development, testing, and deployment of high-quality code Engage with other engineering leaders to implement industry best practices Analyze, troubleshoot, and debug product defects and provide timely solutions to customer needs Develop a deep understanding of PKI products, architecture, and systems What you will have 5+ years of professional experience in the engineering industry Experience designing and developing RESTful web service APIs Strong knowledge of the following: Software engineering best-practices in design, testing, and architecture Service-based architectures and distributed systems Relational databases, including indexes, and SQL best practices Design patterns, data structures, and algorithms Continuous Integration and Continuous Delivery/DevOps Strong interpersonal communication skills Proficiency in Go Language Nice to have Understanding of SSL/TLS, PKI, and other security related technologies Bachelor’s degree in Computer Science, Information Systems, etc., or equivalent years of experience in the industry Technologies we use, any experience is a bonus: MySQL; React / Redux; C++ ; Docker and Kubernetes; Git and GitHub Benefits Generous time off policies Top shelf benefits Education, wellness and lifestyle support

Backdrop AVIZVA is a Healthcare Technology Organization that harnesses technology to simplify, accelerate, & optimize the way healthcare enterprises deliver care. Established in 2011, we have served as strategic enablers for healthcare enterprises, helping them enhance their overall care delivery. With over 14 years of expertise, we have engineered more than 150 tailored products for leading Medical Health Plans, Dental and Vision Plan Providers, PBMs, Medicare Plan Providers, TPAs, and more. Overview Of The Role As a Senior Business Analyst, you are expected to not only manage complex projects and stakeholder relationships but also to lead business analysis efforts across multiple teams or departments. You must have a deep understanding of business processes, technology systems, and industry trends, and drive business value through process optimization, and technology solutions. You will also work closely with the Product Manager, Product Owner(s) and key stakeholders to gather business requirements, and help translate them into clear requirement documents, write compelling business cases and proposals to implement and deliver cost-effective solutions.  Job Responsibilities Conduct requirements elicitation & analysis activities with key focus on business, subject matter, industry trends & standards, data, usability & user experience, through collaboration with Product Owners (PO), Product Managers (PM), Stakeholders & SMEs. Create detailed Product Requirements Documents (PRDs) alongside the PO in accordance with organizational standards. Ensure key elements such as user-journeys, BPMN process flows, wireframes, feature-sets, data requirements, potential integration requirements, and UX nuances. Spearhead end-to-end product UI/UX design activities, collaborating with the PO, and UI/UX designers Leverage your knowledge and understanding of system flows, data flows, API integrations, & databases to define the functional design of your product through collaboration with the POs and BAs/SAs from integrating products and your lead developers. Create detailed system & functional specifications (SFS) in accordance with organizational standards, for your product modules to share functional designs with the product engineering (developers) team highlighting key aspects of system behavior, use-cases, data & integrations. Support the testing/QA team in creating and reviewing test cases, and ensure appropriate clarifications to the development team during the implementation phase. Ensure your documentation (both requirements & specifications) is always up-to-date and is aligned with the developed features in event of changes, enhancements identified during the course of feature development. Play a step-in Product Owner role in the absence of the PO, performing activities such as backlog grooming, team support, Scrum Master (SM) collaboration. Mentor & coach Associate & Specialist BAs in your product team ensuring their success & continued comfort around the nuances of the product, and technicals of the BA role. Drive innovation in BA processes and methodologies along with leadership, introducing improvements based on industry trends, known cases, and popular advancements. Skills & Qualifications Bachelor’s or Master’s degree in any related field or equivalent qualification. 5-8 years of relevant experience in business and/or system analysis. Possess excellent communication, analytical, problem-solving, and critical thinking skills. Expertise around various kinds of requirement documentation formats such as BRD, FRD, SRS, Use-Cases, User-Stories, and creating other documents such as Data Flow Diagrams (DFDs), System Flows, Context diagrams, etc. Possess hands-on experience with BPMN, UML diagrams, and tools like MS Visio, along with basic knowledge and practical exposure to system integrations and APIs. Strong analytical mindset with a proven ability to understand various business problems. Experience in driving UI/UX design activities with designers via enabling tools such as sketches &, wireframes. Familiarity with Atlassian tools (JIRA, & Confluence). Hands-on SQL experience, with comfort around data querying, conceptual & logical data models. Hands-on experience with system integrations and APIs is required. Familiarity with wrapper APIs, ElasticSearch indexes, and AWS S3 will be an added advantage. Experience of working on Healthcare Insurance domain-focused IT products and /or Industry knowledge would be a huge plus.

Job Purpose Seeking a Senior SQL Developer to join our data team in analyzing, developing SSIS projects, custom reports and work closely with the team on any SQL issues. This is an excellent opportunity for an ambitious and agile person looking to grow and learn in a very fast paced environment Duties And Responsibilities Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated. SQL Database Tuning and Performance Design, develop, and maintain database tables, stored procedures, and supporting objects. Build and support operational reports for company and clients. Work with data team to provide operational support, resolve recurring problems. Document database topology, architecture, processes and procedures. Develop SQL queries and support ad hoc requests for data. Assist with capacity planning and resource expansion through data aggregation and analysis. Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement. Identify inefficiencies in the database platform and provide solutions to the management. Use problem-solving skills to assist in resolution of business problems. Develop analytical skills to resolve technical problems. Identify root causes for problems and propose solutions to prevent recurring. Qualifications Requires a four-year degree in Computer Science/Information Technology Minimum five years working as a Database engineer or a related role. Minimum of three years SSIS experience Minimum of two years’ experience with C# and\or VB.NET Thorough understanding of database structures, theories, principles, & practices. Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints. Extensive knowledge of MS SQL Server 2012 or later Extensive knowledge with SSRS\SSIS\T-SQL Experience with C# and\or VB.NET. Technical knowledge of MS SQL Server internals with emphasis on query performance. Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations. Require ability to work independently with minimal supervision Ability to multi-task with several complex and demanding Projects Working Conditions Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress. Work Environment: The noise level in the work environment is usually minimal. Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.

ROLE- SQL DBA Location- Chennai Experience - 5-7 yrs Role and Responsibilities 1. Extensive working knowledge on SQL Server and PostgreSQL 2. Configure DBMS monitoring utilities to minimize false alarms. Implement Automation using PowerShell Scripts. Good Knowledge on PowerShell Scripts is must. 3. Comprehensive implementation knowledge on SSIS, SSAS and SSRS. 4. Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) 5. Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO) 6. Troubleshoot Database service outages as they occur, including after-hours and weekends. 7. As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, SQL Azure, Always ON. 8. Implementation Knowledge on High Availability of Oracle Data Guard, Golden Gate, Always ON & SQL Azure. 9. Install and configure SQL Server, PostgreSQL and Oracle. 10. Deploy database change scripts provided by third party vendors 11. SQL Server Migration experience from SQL older to newer versions. 12. Cross Platform Migration experience (Oracle to SQL & Oracle to DB2 & MySQL to PostgreSQL). 13. When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. 14. Document the company’s database environment. 15. Ensure that new database code meets company standards for readability, reliability, and performance. 16. Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each. 17. Design indexes for existing applications, choosing when to add or remove indexes 18. When users complain about the performance of a particular query, help developers improve performance of that query by tweaking it or modifying indexes. 19. Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.). 20. Implementation experience in Application Performance Tuning and Optimization. Following will the major responsibilities: 1. L2/L3 Microsoft SQL and PostgreSQL Administration 2. Experience in installing, configuring, designing SQL instances 3. Must demonstrate experience to support, optimize and maintain Microsoft SQL 2016/2019 infrastructure with high availability. 4. Working knowledge and hands on experience in On-prem to Azure SQL Server Migration is highly desirable. 5. PowerShell Scripting Knowledge is must. 6. Good communication. 7. Ability to interact and co-ordinate with multiple stakeholders. Some tasks below 1. Monthly patching 2. Cumulative patching. 3. Conduct SQL Server lunch-and-learn sessions for application developers. 4. Knowledge on Virtualization (VMware, Cloud) & Storage concepts Additional Comments: Over all 6-8 Years of Experience with ITIL/ITSM Service Management. Should be willing to work in night shift.

Project Role : Data Platform Engineer Project Role Description : Assists with the data platform blueprint and design, encompassing the relevant data platform components. Collaborates with the Integration Architects and Data Architects to ensure cohesive integration between systems and data models. Must have skills : Snowflake Data Warehouse, Functional Testing Good to have skills : NA Minimum 7.5 Year(s) Of Experience Is Required Educational Qualification : 15 years full time education Summary: As a Data Platform Engineer, you will assist with the data platform blueprint and design, encompassing the relevant data platform components. Your typical day will involve collaborating with Integration Architects and Data Architects to ensure cohesive integration between systems and data models, while also engaging in discussions to refine and enhance the overall data architecture. You will be involved in various stages of the data platform lifecycle, ensuring that all components work harmoniously to support the organization's data needs and objectives. Key Responsibilities: a Overall 12+ of data experience including 5+ years on Snowflake and 3+ years on DBT (Core and Cloud) b Played a key role in DBT related discussions with teams and clients to understand business problems and solutioning requirements c As a DBT SME liaise with clients on business/ technology/ data transformation programs; orchestrate the implementation of planned initiatives and realization of business outcomes d Spearhead team to translate business goals/ challenges into practical data transformation and technology roadmaps and data architecture designs e Strong experience in designing, architecting and managing(admin) Snowflake solutions and deploying data analytics solutions in Snowflake. f Strong inclination for practice building that includes spearheading thought leadership discussions, managing team activities. Technical Experience: a Strong Experience working as a Snowflake on Cloud DBT Data Architect with thorough knowledge of different services b Ability to architect solutions from OnPrem to cloud and create end to end data pipelines using DBT c Excellent process knowledge in one or more of the following areas: Finance, Healthcare, Customer Experience d Experience in working on Client Proposals (RFP's), Estimation, POCs, POVs on new Snowflake features e DBT (Core and Cloud) end to end migration experience that includes DBT migration - Refactoring SQL for modularity, DBT modeling experience (.sql or .py files credbt job scheduling on atleast 2 projects f Knowledge of Jinja template language (Macros) would be added advantage g Knowledge of Special features like DBT documentation, semantic layers creation, webhooks etc. h DBT and cloud certification is important. i Develop, fine-tune, and integrate LLM models (OpenAI, Anthropic, Mistral, etc.) into enterprise workflows via Cortex AI. j Deploy AI Agents capable of reasoning, tool use, chaining, and task orchestration for knowledge retrieval and decision support. k Guide the creation and management of GenAI assets like prompts, embeddings, semantic indexes, agents, and custom bots. l Collaborate with data engineers, ML engineers, and leadership team to translate business use cases into GenAI-driven solutions. m Provide mentorship and technical leadership to a small team of engineers working on GenAI initiatives. n Stay current with advancements in Snowflake, LLMs, and generative AI frameworks to continuously enhance solution capabilities. o Should have good understanding of SQL, Python. Also, the architectural concepts of Snowflake should be clear. Professional Attributes: a client management, stakeholder management, collaboration, interpersonal and relationship building skills b Ability to create innovative solutions for key business challenges c Eagerness to learn and develop self on an ongoing basis d Structured communication written, verbal and presentational. Educational Qualification: a MBA Technology/Data related specializations/ MCA/ Advanced Degrees in STEM

Job Purpose The Senior SQL Developer will design, develop, and maintain database systems, including SSIS projects and custom reports, while collaborating with the data team to address SQL issues and ensure efficient data management within a fast-paced environment. Duties & Responsibilities Develop SSIS projects to handle ETL, transmission, encryption, and archiving files received and generated SQL Database Tuning and Performance Design, develop, and maintain database tables, stored procedures, and supporting objects Build and support operational reports for company and clients Work with data team to provide operational support, resolve recurring problems Document database topology, architecture, processes and procedures Develop SQL queries and support ad hoc requests for data Assist with capacity planning and resource expansion through data aggregation and analysis Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement Identify inefficiencies in the database platform and provide solutions to the management Use problem-solving skills to assist in resolution of business problems Develop analytical skills to resolve technical problems Identify root causes for problems and propose solutions to prevent recurring. Use, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards Understand and comply with Information Security and HIPAA policies and procedures at all times Limit viewing of PHI to the absolute minimum as necessary to perform assigned duties Qualifications Bachelor’s degree in Computer Science/Information Technology required Minimum five years working as a Database engineer or a related role Minimum of three years extensive SSRS\SSIS\T-SQL experience Minimum of two years’ experience with C# and\or VB.NET Thorough understanding of database structures, theories, principles, & practices Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints Extensive knowledge of MS SQL Server 2012 or later with emphasis on query performance Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations Require ability to work independently with minimal supervision Ability to multi-task with several complex and demanding projects Proficiency in Microsoft Office Suite Strong interpersonal skills, ability to communicate well at all levels of the organization Strong problem solving and creative skills and the ability to exercise sound judgment and make decisions based on accurate and timely analyses High level of integrity and dependability with a strong sense of urgency and results oriented Excellent written and verbal communication skills required Gracious and welcoming personality for customer service interaction Working Conditions Work Set-Up: Fully Remote Work Schedule: US Hours (Night Shift) Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress. Work Environment: The noise level in the work environment is usually minimal. Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.

Location: Mumbai - Onsite Company: 9Point Capital – India’s first digital asset management firm Type: Full-time | Immediate Joining Preferred About 9Point Capital At 9Point Capital, we are building India’s first institutional-grade platform offering access to global regulated digital assets like Bitcoin ETFs, US equities, and crypto products. As we scale our systematic trading desk, we are hiring a Quant Developer who will help us design, develop, and deploy highly scalable, production-grade infrastructure for live algorithmic trading. Role Overview As a Quant Developer , you will play a pivotal role in automating and optimizing our quantitative trading strategies across asset classes including crypto, equity indexes, and volatility derivatives. This is a hands-on engineering role , ideal for someone passionate about market structure, trading infrastructure, and building fault-tolerant systems for 24/7 execution. Key Responsibilities Systematic Strategy Automation: Build and automate live trading strategies (Delta-1 and Options) across crypto and global equity indices. Full Stack Trading Infrastructure: Develop core trading components including: Signal ingestion and processing Low-latency execution engines Real-time portfolio risk management P&L attribution and reconciliation pipelines Robust Engineering: Write clean, modular, production-grade Python code with full error handling, edge-case management, and graceful recovery features. Cross-Venue Execution: Build and maintain systems that integrate with both crypto and traditional finance execution platforms via FIX, REST, and WebSocket APIs for spot, futures, and options trading. Collaboration: Work closely with traders, quantitative researchers, and product leads to convert models into robust, live strategies that run 24/7. Required Skills Strong Python Engineering: Exceptional grasp of object-oriented programming and design patterns Experience with backtesting frameworks and real-time data handling Experience with Real-Time Systems: Prior exposure to event-driven or asynchronous architectures Building low-latency , scalable , and fault-tolerant systems Understanding of Financial Markets: Knowledge of market microstructure , order types, execution algorithms, and slippage Comfort with both crypto markets and traditional financial markets System Integration: Familiarity with trading APIs (REST, FIX, WebSockets) Experience with message queues or pub-sub systems (e.g., Kafka, ZeroMQ) Bonus Skills Experience with C++ or other low-latency programming languages Understanding of volatility surfaces , options Greeks , or portfolio optimization Exposure to cloud-native deployments , Docker, Kubernetes Familiarity with Grafana , Prometheus , or similar monitoring tools What We Offer An opportunity to work on the cutting edge of finance and technology A high-impact role where your systems directly contribute to alpha generation Dynamic, intellectually stimulating environment with access to global markets Competitive compensation with performance-linked bonuses Join Us If you are passionate about markets and systems, and you love building real-world, high-performance trading platforms, we would love to speak with you.

Salary INR : 12 - 15 Job Title : SQL Developer Experience : 3-5 yrs Location : Faridabad Education : Any Graduation Skills : Sql, Mysql, Views, MSSql, Functions, Triggers, Indexes, SSIS, Optimizations of query etc. Requrirements Previous working experience as a MySQL Developer for (3-5) year(s) Strong proficiency in MySQL database management Decent experience with recent versions of MySQL Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM Knowledge of MySQL features, such as its event scheduler, Trigger, Views, functions. Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases Proficient in writing and optimizing complex SQL queries; Identify bottlenecks in database performance and tuning database and SQL queries Ensure availability, reliability and security of the database in production and staging environments Knowledge of various tools for data and schema import/export Ensure data integrity and the detection of data errors Index design and usage is SQL Queries (ref:hirist.tech)

Core Responsibilities: Design and maintain scalable and efficient database schemas based on business and application needs. Develop, optimize, and troubleshoot SQL queries, stored procedures, functions, and triggers. Create and manage tables, indexes, and relationships; maintain deployment scripts with support for versioning and rollback. Collaborate with API developers by providing required database support, including dummy data, data cleanup scripts, and performance insights. Assist ETL and Development teams involving databases such as Oracle, MySQL, Sybase, and SQL Server. Perform database maintenance tasks: backups, restores, indexing, statistics updates, and performance tuning. Ensure data security, integrity, and compliance with organizational policies. Maintain clear and up-to-date documentation for schemas, procedures, and deployment processes. Stay informed of industry trends and proactively suggest improvements or new tools. Required Qualifications: 34 years of hands-on experience with Microsoft SQL Server (2016 or later). Strong knowledge of T-SQL: scripting, stored procedures, views, functions, and triggers. Experience in data modeling, normalization, and schema design. Familiarity with CI/CD practices related to database deployment (e.g., upgrade/rollback scripts). Exposure to data migration projects involving multiple RDBMS platforms (e.g., Oracle, MySQL, Sybase). Experience collaborating with cross-functional teams (developers, QA, DevOps). Preferred/Bonus Skills: Working knowledge of MongoDB: schema design, indexing, aggregations. Experience with performance tuning, execution plans, and database optimization strategies. Familiarity with automation/scripting tools (PowerShell, Python, etc.) for database tasks. Understanding of database security, access control, and auditing. Exposure to backup and high-availability strategies (e.g., Always On, Log Shipping, Mirroring). Experience working with cloud-based databases (e.g., Azure SQL Database, Amazon RDS, MongoDB Atlas). Soft Skills: Strong analytical and troubleshooting abilities. Excellent communication and documentation skills. Ability to work independently and in team settings. Organized, detail-oriented, and proactive in identifying areas for improvement.

About Oracle Customer Success Services(CSS): As a key member of Oracle Customer Success Services, you will join an international network of experts dedicated to driving customer success through innovation and expertise. Our One Oracle approach ensures you will be part of a team delivering comprehensive, end-to-end services and solutions that accelerate the entire customer journey. Work alongside certified and experienced professionals, gaining exposure to cutting-edge technologies and methodologies, and enhancing your skills and credentials. Engage with a diverse range of customers, managing the full lifecycle of delivery and services, and ensuring each project has a tangible impact. Benefit from robust team support in a collaborative environment that prioritizes teamwork and mutual success. Join us in Oracle Customer Success Services and elevate your career with a company that values innovation, expertise, and customer-centric solutions Career Level - IC4 Mandatory Skills: Should have 8+ years of experience in Oracle SQL query tuning expertise. Strong expertise in writing and understanding of Oracle SQL/PLSQL Functional knowledge of Oracle Fusion Middleware products, Weblogic & Database products. Interpreting explain plans and able to read AWRs and ASH for identifying SQL query bottle necks. Ability to interpret explain plans for access path, predicate filtering and high knowledge of joins and orders in table access. Advanced knowledge of SQLHC, parallel query knowledge. Should have rich experience in factored / scalar sub-queries and ability to utilise them in sql queries. Strong decision making, convincing skills to bring down the complex discussions to closure supported by right arguments and facts. Understanding of database initialization parameters, logs and traces. Experience working on complex software development/integration projects Experience in scripting tool like Unix shell, Python, Perl Optional hands on troubleshooting Oracle OTBI & BIP report issues and performance related techniques on components like Data models/sets, LOV, parameters , bursting, FF, scheduling. Good to Have Skills: Understanding of AI and Machine learning will be an added advantage. Oracle SQL performance diagnostic tools like SQLHC Experience in using monitoring tools like OEM. Building synthetic test cases. Responsibilities: Optimize Oracle SQL: Diagnose and resolve individual SQL performance issues (you would need to apply hints, define new indexes, investigate optimiser/environment issues) . Early Adopter of Innovation: Explore and adopt new technologies like Oracle 23ai, Autonomous DB, Auto indexing, AI related tools. Analysis and Optimize Oracle BIP Reports: Should be able to help customer to identify performance issues with Oracle BIP reports functionality and sql queries involved with them. Optional knowledge of various components of BIP reports like Data models, Parameters, LOVs, Flex Fields, Bursting. Should be able to advise customers to use right sql queries as per Oracle best practices and which aids in completing the report optimally. OTBI and BIP reports: Knowledge of troubleshooting OTBI reports for advising customers to use performance enhancing configuration parameters.

Project Role : Data Platform Engineer Project Role Description : Assists with the data platform blueprint and design, encompassing the relevant data platform components. Collaborates with the Integration Architects and Data Architects to ensure cohesive integration between systems and data models. Must have skills : Snowflake Data Warehouse Good to have skills : Data Engineering Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary: As a Data Platform Engineer, you will assist with the data platform blueprint and design, encompassing the relevant data platform components. Your typical day will involve collaborating with Integration Architects and Data Architects to ensure cohesive integration between systems and data models, while also engaging in discussions to refine and enhance the overall data architecture. You will be involved in various stages of the data platform lifecycle, ensuring that all components work harmoniously to support the organization's data needs and objectives. Key Responsibilities: a Overall 12+ of data experience including 5+ years on Snowflake and 3+ years on DBT (Core and Cloud) b Played a key role in DBT related discussions with teams and clients to understand business problems and solutioning requirements c As a DBT SME liaise with clients on business/ technology/ data transformation programs; orchestrate the implementation of planned initiatives and realization of business outcomes d Spearhead team to translate business goals/ challenges into practical data transformation and technology roadmaps and data architecture designs e Strong experience in designing, architecting and managing(admin) Snowflake solutions and deploying data analytics solutions in Snowflake. f Strong inclination for practice building that includes spearheading thought leadership discussions, managing team activities. Technical Experience: a Strong Experience working as a Snowflake on Cloud DBT Data Architect with thorough knowledge of different services b Ability to architect solutions from OnPrem to cloud and create end to end data pipelines using DBT c Excellent process knowledge in one or more of the following areas: Finance, Healthcare, Customer Experience d Experience in working on Client Proposals (RFP's), Estimation, POCs, POVs on new Snowflake features e DBT (Core and Cloud) end to end migration experience that includes DBT migration - Refactoring SQL for modularity, DBT modeling experience (.sql or .py files credbt job scheduling on at least 2 projects f Knowledge of Jinja template language (Macros) would be added advantage g Knowledge of Special features like DBT documentation, semantic layers creation, webhooks etc. h DBT and cloud certification is important. i Develop, fine-tune, and integrate LLM models (OpenAI, Anthropic, Mistral, etc.) into enterprise workflows via Cortex AI. j Deploy AI Agents capable of reasoning, tool use, chaining, and task orchestration for knowledge retrieval and decision support. k Guide the creation and management of GenAI assets like prompts, embeddings, semantic indexes, agents, and custom bots. l Collaborate with data engineers, ML engineers, and leadership team to translate business use cases into GenAI-driven solutions. m Provide mentorship and technical leadership to a small team of engineers working on GenAI initiatives. n Stay current with advancements in Snowflake, LLMs, and generative AI frameworks to continuously enhance solution capabilities. o Should have good understanding of SQL, Python. Also, the architectural concepts of Snowflake should be clear. Professional Attributes: a client management, stakeholder management, collaboration, interpersonal and relationship building skills b Ability to create innovative solutions for key business challenges c Eagerness to learn and develop self on an ongoing basis Educational Qualification: a MBA Technology/Data related specializations/ MCA/ Advanced Degrees in STEM 15 years full time education

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI) Specialist 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 c onduct 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. 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. Skills: Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 302894

A database administrator (DBA) manages, maintains, and secures an organization's databases. They ensure data is stored, organized, and accessible for users to perform business-related tasks and analyses. DBAs are responsible for database performance, security, and integrity. Key Responsibilities: Database Design and Implementation: DBAs design and implement database structures, including tables, indexes, and stored procedures, based on organizational needs. Database Management: They manage database servers, including installation, configuration, and maintenance. Security: DBAs implement security measures to protect sensitive data, including access controls, encryption, and auditing. Performance Tuning: They monitor database performance and optimize it for efficiency. Backup and Recovery: DBAs create and test backup and recovery procedures to prevent data loss. Troubleshooting: They diagnose and resolve database-related issues, ensuring data availability and integrity. Data Integrity: DBAs ensure data accuracy and consistency through validation rules and data quality procedures. User Support: They provide training and support to users on database usage and best practices. Collaboration: DBAs work with developers, data architects, and other stakeholders to design, implement, and maintain database systems. Staying Updated: They keep up-to-date with new database technologies and security best practices. Documentation: DBAs create and maintain documentation related to database design, configuration, and procedures. Skills: Technical Skills: Strong understanding of database management systems (DBMS), SQL, database design principles, and operating systems (like Linux or Windows). Analytical Skills: Ability to analyze data, identify performance bottlenecks, and troubleshoot issues. Communication Skills: Ability to communicate technical information to both technical and non-technical audiences. Problem-Solving Skills: Ability to identify and resolve complex database issues. Security Awareness: Understanding of database security principles and best practices. Tamil candidates only Job Types: Full-time, Permanent Pay: ₹311,151.40 - ₹1,341,354.45 per year Benefits: Food provided Schedule: Day shift Supplemental Pay: Yearly bonus Work Location: In person

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI)/ PL SQL Specialist 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. I deally, you should also have Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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) 3 -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 3-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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 303091

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI)/ PL SQL Specialist 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. I deally, you should also have Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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) 3 -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 3-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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 303091

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI) Specialist 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 c onduct 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. 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. Skills: Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 302894

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI) Specialist 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 c onduct 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. 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. Skills: Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 302894

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI)/ PL SQL Specialist 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. I deally, you should also have Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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) 3 -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 3-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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 303091

Summary Position Summary AI & Data In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment. The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets. Oracle Data Integrator (ODI)/ PL SQL Specialist 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. I deally, you should also have Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle objects 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-Premises 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) 3 -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 3-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 objects 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. How You’ll Grow At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte’s culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community. Our purpose Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Our people and culture Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work. Professional development At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India . Benefits To Help You Thrive At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you. Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Requisition code: 303091