Senior ETL Developer

1 month ago

bangalore, India Celeros Flow Technology Full time

Job Summary

 

The Senior ETL Developer will work on developing and maintaining the ETL process as part of the IT Digital, Data, and Analytics Team at Celeros Flow Technology. This individual will work with the Data Analytics Analyst and Businesses to document field mapping, business rules, and business logic required to transform master and transactional data from various ERP systems into the analytical databases. This individual will design and deliver the end-to-end ETL process and Data Analytics technology infrastructure that will feed data to dashboards, scorecards, standard reports, ad hoc self-service reports, discovery & analysis, and comprehensive visualizations. The Senior ETL Developer has proven experience providing technology solutions to support key business processes and providing troubleshooting support in a Global Manufacturing Company. This individual will report to the Manager of the IT Digital, Data, and Analytics Team. This role will be based at our Bangalore office.

 

Principle Duties and Responsibilities

 

  • Translate BI Data Analytics needs into requirements by holding requirements gathering sessions and collaborating with stakeholders throughout the company in Finance, Product Management, Sales, Engineering, Manufacturing Operations, and Supply Chain groups. Document mapping and transformation rules from reports to source system fields in SAP (ECC6) and non-SAP ERP systems and other applications.
  • Design, estimate and create a project plan for development, testing, and implementation of ETL process and related tasks.
  • Develop robust and scalable ETL process in SAP Business Objects Data Services (BODS) for source SAP and non-SAP systems and target OLAP systems (SQL, etc.).
  • Install and configure the BODS application.
  • Monitor BODS jobs, perform fast troubleshooting and root cause analysis, and provide fast turnaround with a resolution of job failure and any other issues in the BODS production system.
  • Profile source data using SAP Information Steward and discuss results with IT Analyst Business SMEs to define Data Quality checks for Business and IT action.
  • Gather, analyze, and identify opportunities for enhancements; work closely with business and technology partners to seek and provide effective resolution to business issues.
  • Define the engagement success criteria with business users, track and monitor progress during engagements and ensures deliverables are met.
  • Identify and implement solutions to enhance the existing BI infrastructure process and technology, and potentially move to newer BI infrastructure technologies to support the long term roadmap.
  • Create documentation to assist business users and IT members in designing & effectively using the solutions developed.
  • Deliver against the data strategy to support the development and deployment of executive dashboards, operational dashboards, standard reports, ad hoc reports, discovery & analysis.
  • Communicate and report project progress related to schedule and work performance to the necessary stakeholders.
  • Ability to quickly learn reports development in Power BI and other analytics applications.
  • Create technical design and data flow diagrams of BI platform and ETL processes.
  • Ability to work independently with minimal supervision.
  • Can manage own tasks and deliverables.

 

 

 

 

Knowledge, Skills and Abilities

  • 7-10 years of demonstrated technical mastery of Design, Development, and Deployment of
  • SAP Business Objects Data Services and MSFT ETL applications.
  • 7-10 years of experience developing ETL process with SAP and non-SAP source systems.
  • 5+ years of experience working with SAP (ECC6), SQL, and other data warehouse & OLAP applications.
  • Strong development and implementation expertise in SAP Information Steward and Data
  • Quality, experienced in master data management and governance creating, publishing, and
  • maintaining data quality rules & scorecards.
  • Designing complex SAP Data Services job flows to extract from and load to SAP systems and
  • SQL Servers, including delta loads to improve ETL performance.
  • Sound knowledge of BODS scheduling and Management Console.
  • Strong knowledge of SQL, star schema, data modelling and data warehouse concepts.
  • Experience with Data Integration transforms such as Query, Validation, Case transforms as
  • well as Data Quality transforms such as Match, Associate & Data Cleanse and other
  • transforms.
  • Tuning jobs for high volume and complex transformation scenarios.
  • Configuring BODS components including job server, repositories and service designers.
  • Strong expertise with SQL Scripting, creating SSIS packages and DB migrations.
  • Reconciling loaded data with Legacy System.
  • Experience in designing and implementing ETL solutions for various non-SAP ERP
  • technologies.
  • Sound understanding and knowledge of SAP FICO, SD, MM/Pur, PP data and tables.
  • Strong knowledge of SQL server and database.
  • Experience with creating and maintaining SQL servers and databases.
  • Experience in creating the technical design, architecture, and data flow diagrams for BI and
  • analytics applications.

 

Education and Experience

  • B.Tech/B. E/MCA/ / Masters in Business Systems Analysis in a relevant stream through the regular course from recognized university and institute in India
  • 7-10 years of relevant experience in SAP BODS and ETL applications and working in a global organization
  • One or more business intelligence certifications (SAP, Microsoft SQL/Azure, GCP, etc.)

 

 

  • Senior Manager

    1 month ago

    bangalore, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • Senior ETL Developer

    1 month ago

    bangalore, India Corporate Resources Full time

    Job Description Contributing and developing ETL processes to facilitate data archival activities from a variety of source databases into a central repository using, primarily, Talend Data Integration set of tools. Validating of archived information completeness, and integrity. Upkeeping of the...

  • ETL Developer

    1 month ago

    bangalore, India White Force Full time

    Job Description: Job Description: We are Hiring a ETL developer Skill : ETL, ETL process management, Determine data storage needs, Data analysis, ETL process.

  • ETL Developer

    1 week ago

    bangalore, India Niotact Digital Solutions Full time

    Lead the design, development, and optimization of ETL processes using Ab Initio's Graphical Development Environment (GDE), ensuring data accuracy, consistency, and availability. Data Integration: Build, maintain, and optimize data integration workflows, enabling seamless data flow across various systems and platforms.Experience in Data Transformation,...

  • ETL Developer with RestAPI

    3 weeks ago

    bangalore, India Cognisol Full time

    Job Description: Are you an experienced dataintegration professional with a strong proficiency in ETL Do youhave a knack for transforming and manipulating data using Rest APIsSQL and JSON If youre passionate about creating efficient andeffective ETL solutions we invite you to join our team as a ETLSpecialist.Key Responsibilities: Design develop andimplement...

  • ETL Datastage Developer

    2 days ago

    bangalore, India Quess Full time

    About Us “Quess IT Staffing is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names...

  • Analytics Saves At Work

    1 month ago

    Bangalore, India Analytics Saves At Work India Pvt Ltd. Full time

    Job Role : DataMart Senior Developers. Location : Bangalore, India. Experience : 5+ years. Analytics Saves at Work is looking for DataMart Senior Developers for one of its clients. A DataMart Developer is responsible design, develop and modify relational and multidimensional database. structures, relationships, data flows and data interfaces within the...

  • Analytics Saves At Work

    4 weeks ago

    Bangalore, Karnataka, India Analytics Saves At Work India Pvt Ltd. Full time

    Job Role : DataMart Senior Developers.Location : Bangalore, India.Experience : 5+ years.Analytics Saves at Work is looking for DataMart Senior Developers for one of its clients. A DataMart Developer is responsible design, develop and modify relational and multidimensional database. structures, relationships, data flows and data interfaces within the data...

  • ETL Developer

    3 weeks ago

    Bangalore, Karnataka, India CIEL HR Full time

    Job Summary :- We are seeking an experienced ETL Developer to join our team.- The ETL Developer will be responsible for designing, developing, implementing, and maintaining ETL processes for our data warehouse.- The ideal candidate will have a strong understanding of ETL principles, data modeling, and database concepts, along with experience working with...

  • ETL Developer

    1 week ago

    Bangalore/Hyderabad, India Hitya Global Full time

    Job Position : We are seeking an ETL Sr Software Engineer who will be responsible for analysis, design, and implementation of code/workflows/sessions/mappings/query changes within application and provide end to end application support. ETL SSE's primary role will be to have an end-to-end responsibility in data Migration from Legacy system to HR Payor...

  • ETL Developer

    1 week ago

    Bangalore/Hyderabad, Karnataka, India Hitya Global Full time

    Job Position :We are seeking an ETL Sr Software Engineer who will be responsible for analysis, design, and implementation of code/workflows/sessions/mappings/query changes within application and provide end to end application support. ETL SSE's primary role will be to have an end-to-end responsibility in data Migration from Legacy system to HR Payor...

  • ETL developer

    1 week ago

    bangalore, India Quess Full time

    About Us “Quess IT Staffing is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names...

  • Senior Software Engineer

    1 month ago

    bangalore, India JLL Full time

    About the role We are looking for a Senior Resource to join our JLL Technologies - CoE organization in Bangalore, India. This role requires partnering with the broader JLL Technology team at the country, regional and global level by utilizing in-depth knowledge of data, infrastructure, technologies and data engineering experience The role will add...

  • Senior Test Engineer

    1 month ago

    bangalore, India Victoria's Secret Full time

    Description Senior Test Engineer Overview: This is an individual contributor role that will be responsible for QA test execution with minimal supervision. This position is responsible for the identification of test scenarios / test cases and execution of application testing. This includes the identification of Functional, Technical and...

  • ETL Developer

    2 weeks ago

    Bangalore, India CONGRUENCE HR PRIVATE LIMITED Full time

    Mandatory Skills:- Rest API, ETL, JSON, Data Integration, Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data...

  • ETL Developer

    1 month ago

    bangalore, India CONGRUENCE HR PRIVATE LIMITED Full time

    Mandatory Skills:- Rest API, ETL, JSON, Data Integration, Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data...

  • ETL Developer

    4 weeks ago

    Bangalore, Karnataka, India CONGRUENCE HR PRIVATE LIMITED Full time

    Mandatory Skills:- Rest API, ETL, JSON, Data Integration, Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data...

  • ETL Developer

    2 weeks ago

    Bangalore, India Trothandally Full time

    Roles & Responsibilities : - Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data integration and exchange...

  • ETL Developer

    1 month ago

    bangalore, India Trothandally Full time

    Roles & Responsibilities : - Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data integration and exchange...

  • ETL Developer

    4 weeks ago

    Bangalore, Karnataka, India Trothandally Full time

    Roles & Responsibilities :- Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data integration and exchange...