Data Management -ETL

Highlight of the engagement opportunity

• Nature of role:

  Full time

• Number of years of experience expected:

  5 to 10 years.

• 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.

• Technology proficiency preferred:

  MSSQL, PostgreSQL, Python, Informatica, SSIS, cloud proficiency, SAS Data Integration Studio, Informatica PowerCenter, Oracle Data Integrator

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 careers@acies.holdings.

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