Data Management -ETL

Acies; Mumbai; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A leading technology consultancy in Mumbai is seeking a lead Data management and ETL expert to manage data mapping and transformation processes. The candidate should have 5-10 years of experience in Python, ETL development, and data warehousing. Responsibilities include leading ETL processes, ensuring data integrity, and mentoring team members. Ideal candidates will have a BTech or MBA and strong technical skills in ETL tools and data quality checks. The role offers the opportunity to contribute to innovative projects in a dynamic environment.

Qualifications

• 5 to 10 years of experience in Python, with 2+ years expected.
• Experience in ETL documentation, data mapping, and finance data.
• Ability to write and speak fluently in English.

Responsibilities

• Lead end-to-end ETL architecting and development process.
• Implement data quality checks and reconciliation processes.
• Manage and mentor a team of ETL developers.

Skills

Python

pandas

NumPy

SQL database

Oracle database

Apache Airflow

Informatica

Education

BTech

MBA

Data science courses

Job description

• Number of years of experience expected: 5 to 10 years 2+ years of experience in Python. And must know pandas and NumPy libraries
• Areas of past experience preferred: ETL documentation / Data mapping / ETL development / Python / Risk data / Finance data
• Educational qualification required: BTech / Product courses / MBA/ Data science courses.
• Additional certifications preferred: Results-oriented with a track record of successfully delivering complex data projects.
• Preferred geography of previous work experience: India / Europe / APAC / US
• Language requirements: Ability to write and speak fluently in English.

Acies Technology Implementation practice is seeking a lead Data management and ETL expert for handling data mapping, transformation, ETL processes and client communication across all of Acies Product implementations. The ideal candidate will be responsible for designing, developing, and implementing efficient ETL processes, ensuring data integrity, and leading a team of ETL developers and data mapping leads. The role requires a deep understanding of data warehousing, ETL tools, and best practices in data integration across risk and finance domain. If you are passionate about technology and thrive in a dynamic, collaborative environment, we invite you to apply and contribute to our innovative projects.

Key responsibility areas:

• Lead the end-to-end ETL architecting, development process, from requirements gathering to implementation and maintenance.
• Undertake data structure mapping between the Product and customer datasets and identify scenario of any gaps.
• Implement rigorous data quality checks, validation scripts, and reconciliation processes to guarantee data accuracy and integrity post-migration.
• Ability to process scenarios during discussions related to data quality and validation logics associated with the client datasets
• Develop and maintain comprehensive technical documentation for all data migration processes, including design specifications, ETL mappings, and troubleshooting guides.
• Collaborate with cross-functional teams to understand data requirements and deliver high-quality data solutions.
• Manage and mentor a team of ETL developers, providing technical guidance and support.
• Perform data profiling, validation, and quality checks to ensure data accuracy.
• Optimize ETL processes for performance and efficiency.
• Collaborate with stakeholders to define data integration strategies and requirements
• Collaborate with cross-functional teams to define project scope, goals, and deliverables.
• Develop comprehensive project plans, including timelines, resource allocation, and budgets.
• Ensure effective communication with stakeholders to manage expectations and project progress.
• Identify and mitigate project risks, troubleshooting issues to ensure project success.
• Strong scripting skills in languages such as Python and/or Shell scripting for data manipulation, automation, and process control.

Selection process:

We seek to be transparent during the selection process. While the actual process may vary from the process indicated below, the key steps involved are as follows:

• Personal interviews: There are expected to be at least 2 rounds of online interviews. The number of interview rounds may increase depending on the criticality and seniority of the role involved.
• Final discussion on career and compensation: Post final selection, a separate discussion will be set up to discuss compensation and career growth. You are encouraged to seek any clarifications you have during this discussion.

Preparation required:

It is recommended that you prepare on some of the following aspects before the selection process:

• Demonstrate knowledge about data management, ETL, data pipelines
• Demonstrate knowledge about SQL database, Oracle database, Python, Apache Airflow and / or Informatica

For any additional queries you may have, you can send a LinkedIn InMail to us, connect with us at https://www.acies.consulting/contact-us.php or e-mail us at [e-mail].

How to reach us:

Should you wish to apply for this job, please reach out to us directly through LinkedIn or apply on our website career page - https://www.acies.consulting/careers-apply.html