4 Scds Jobs

JOB DESCRIPTION Job Summary If you are looking for an opportunity in Technology Solutions and Development, Emerson has this exciting role for you! The Senior ETL Developer - Oracle will be partof team of individuals whose responsibility is to develop ETL programs and to improve the performance of poorly written or poorly performing applications code in Oracle Data Integrator tool. This will include existing code and new code which have not yet been promoted to production. This team delivers technology solutions for strategic business needs, drives adoption of these services and support processes and boosts value by enhancing our customers experience. This role work along a hardworking and dedicated team of self-motivated professionals who share a collective passion for progress and excellence. In this Role, Your Responsibilities Will Be: Candidate will be responsible to design end to end solutions to cater to business needs of data in Oracle BI Tool stack especially ODI and SQL. Expertise in designing custom Data warehouse solutions specific to business needs. Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design Expertise in preparing Data lineage sheets. Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs. Experience of automating various ETL jobs, failure notification etc Ability to review and suggest DWH Design optimization solutions. Expertise in performance tuning of mappings in ODI and SQL query tuning. Production Support of Daily running ETL loads, monitoring, troubleshooting failures and bug fixing across environments Expertise in Multiple databases (Oracle/ SQL Server/etc) including complex SQL, query debug and optimization Should have strong understanding of Business Analytics, data warehouse analysis, design, development & testing Who You Are: You show a tremendous amount of initiative in tough situations are exceptional at spotting and seizing opportunities. You observe situational and group dynamics and select best-fit approach. You make implementation plans that allocate resources precisely. You pursue everything with energy, drive, and the need to finish. For This Role, You Will Need: 8+ years of relevant experience working in OBIA on ODI as the ETL tool in BIAPPS environment. Exposure to working in other ETL tools. Ability to work on highly complex problems and provide feasible solutions in time. Ability to review and suggest improvements in existing DWH solution. Ability to work in a demanding user environment. Ability to provide trainings on ETL, DWH and Dimensional modelling. Ability to guide and help team members in technical issues. Strong Written and Oral communication skills. Coordinating among various teams for day to day activity. Preferred Qualifications that Set You Apart: Bachelor's degree or equivalent in Science with a technical background (MIS, Computer Science, Engineering or any related field) Good interpersonal skills using English, both spoken and written, as will be working with overseas team Our Culture & Commitment to You At Emerson, we prioritize a workplace where every employee is valued, respected, and empowered to grow. We foster an environment that encourages innovation, collaboration, and diverse perspectives-because we know that great ideas come from great teams. Our commitment to ongoing career development and growing an inclusive culture ensures you have the support to thrive. Whether through mentorship, training, or leadership opportunities, we invest in your success so you can make a lasting impact. We believe diverse teams, working together are key to driving growth and delivering business results. We recognize the importance of employee wellbeing. We prioritize providing competitive benefits plans, a variety of medical insurance plans, Employee Assistance Program, employee resource groups, recognition, and much more. Our culture offers flexible time off plans, including paid parental leave (maternal and paternal), vacation and holiday leave.

If you are seeking an opportunity in Technology Solutions and Development, Emerson has an exciting role for you! As a Senior ETL Developer - Oracle, you will be a part of a team responsible for developing ETL programs and enhancing the performance of applications code in Oracle Data Integrator tool. Your duties will involve working on existing code and developing new code to meet production standards. This role contributes to delivering technology solutions for strategic business needs, promoting service adoption, supporting processes, and enhancing customer experience. You will collaborate with a diligent team of professionals who share a passion for progress and excellence. Your responsibilities in this role include designing end-to-end solutions to meet data business requirements in Oracle BI Tool stack, particularly ODI and SQL. You will specialize in developing custom Data warehouse solutions tailored to business needs and possess expertise in Dimensional Modelling, preparing Data lineage sheets, Data warehousing concepts, and Database concepts. Proficiency in ODI development, performance tuning, automating ETL jobs, and optimizing DWH design are key aspects of this role. Additionally, you will provide production support for ETL loads, monitor performance, troubleshoot failures, and fix bugs across environments. To excel in this role, you must demonstrate a high level of initiative, problem-solving skills, and resource allocation abilities. Strong communication skills, the ability to work on complex problems and provide timely solutions, and a knack for guiding and assisting team members in technical matters are essential. A background in Science with technical expertise, interpersonal skills, and the ability to work in a demanding environment are preferred qualifications. At Emerson, we cultivate a workplace where every employee is respected, valued, and empowered to grow. We foster innovation, collaboration, and diverse perspectives to drive growth and achieve business results. We are committed to your ongoing career development and well-being, offering competitive benefits, medical insurance plans, employee resource groups, flexible time off, and support for your success. Join our team and make a lasting impact in a culture that prioritizes inclusivity and growth.,

As an Oracle Data Integrator (ODI) Professional at YASH Technologies, you will play a key role in providing prompt and effective support, maintenance, and development on OBIA based Analytics Datawarehouse using ODI as the underlying ETL Tool. Your responsibilities will include implementation, development, and maintenance of the ODI environment, data warehouse design, dimensional modeling, ETL development & support, as well as ETL performance tuning. You will be responsible for solution design, implementation, migration, and support in the Oracle BI Tool stack, particularly ODI and SQL. Your tasks will involve ODI development in an OBIA Environment, enhancements, support, and performance tuning of SQL programs. Additionally, you will be involved in data warehouse design, development, and maintenance using Star Schema (Dimensional Modeling). Your role will also encompass production support of daily running ETL loads, monitoring, troubleshooting failures, bug fixing across environments, and working with various data sources including Oracle, CRM, Cloud, Flat Files, Sharepoint, and other non-Oracle systems. Experience in performance tuning of mappings in ODI and SQL query tuning will be essential. To succeed in this role, you should have 5-7+ years of relevant experience working in OBIA on ODI as the ETL tool in a BIAPPS environment. Strong written and oral communication skills, the ability to work in a demanding user environment, and knowledge of tools like Serena Business Manager and ServiceNow are crucial. A B.Tech / MCA qualification is required, and competencies such as being tech-savvy, effective communication, optimizing work processes, and cultivating innovation are essential. At YASH, you will have the opportunity to create a career path in an inclusive team environment that supports continuous learning and development. Our Hyperlearning workplace is grounded on principles such as flexible work arrangements, agile self-determination, trust, transparency, and stable employment with an ethical corporate culture. Join us at YASH Technologies and be part of a team that fosters positive changes in an ever-evolving virtual world.,

Key Responsibilities: Design, develop, and implement ETL processes using Informatica Power Center to extract, transform, and load data from various sources. Analyze business requirements and translate them into technical solutions. Optimize existing ETL jobs for performance, scalability, and reliability. Perform unit testing, integration testing, and support UAT phases. Ensure data accuracy, integrity, and consistency across all data sources and destinations. Create and maintain technical documentation and data flow diagrams. Collaborate with data architects, DBAs, business analysts, and QA teams. Troubleshoot production issues and provide timely resolutions. Key Skills Required: Proficiency in Informatica Power Center (v9.x or higher) Strong understanding of ETL best practices, data profiling, and performance tuning Experience working with relational databases (Oracle, SQL Server, Teradata, etc.) Solid SQL and PL/SQL skills for data validation and transformation logic Familiarity with data warehousing concepts (star/snowflake schema, SCDs, fact/dimension tables) Experience with workflow scheduling tools like Control-M, Autosys, or TWS is a plus Knowledge of Informatica Administration and version control is an advantage