Sr Data Specialist - R01568425

Brillio 2; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Brillio is seeking a Lead Data Engineer in Pune to design and manage robust ETL pipelines using Informatica MDM. The role emphasizes data modeling, data governance, and scalable warehouse solutions.

You will lead SQL-based transformations, collaborate with cross-functional teams, and optimize data platforms using Python for automation and performance tuning.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Informatica MDM or ETL technologies certifications are a plus.
• Hands-on experience with data governance practices.

Responsibilities

• Design and implement ETL pipelines using Informatica MDM for enterprise data integration.
• Develop, optimize, and maintain complex SQL, PLSQL, and T-SQL stored procedures for data processing.
• Lead data modeling initiatives translating business requirements into scalable data warehouse solutions.
• Collaborate with cross-functional teams to gather requirements and deliver insights.
• Troubleshoot data issues to ensure high availability and performance of ETL workflows.
• Automate data ingestion and transformation tasks using Python.
• Monitor ETL performance and optimize for throughput.
• Adhere to data governance policies ensuring data integrity and security.

Skills

Informatica MDM

ETL pipeline development with Informat

Advanced SQL programming

Python for data engineering

Enterprise data warehousing

Data modeling for large-scale systems

PL/SQL

T-SQL

Stored procedures development

Education

Bachelor’s degree in Computer Science / Information Technology or related field

Tools

Azure Data Factory

AWS Glue

Spark

Hadoop

Job description

Lead Data Engineer

• ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
• ETL Specialization: Data Engineer
• Experience Range: 4 to 6 years of experience, including hands-on expertise in ETL and Informatica MDM solutions Key Responsibilities: 1. Design and implement robust ETL pipelines using Informatica MDM to ensure accurate data integration and management across enterprise systems 2. Develop, optimize, and maintain complex SQL, PLSQL, and T-SQL stored procedures for efficient data processing and transformation 3. Lead data modeling initiatives, translating business requirements into scalable data warehouse solutions and modern data platform architectures 4. Collaborate with cross-functional teams to gather requirements, validate data quality, and deliver actionable insights through advanced data engineering practices 5. Troubleshoot and resolve data-related issues, ensuring high availability, reliability, and performance of ETL workflows 6. Automate data ingestion and transformation tasks using Python, enhancing operational efficiency and reducing manual intervention 7. Monitor and improve ETL performance, proactively identifying bottlenecks and implementing enhancements to achieve optimal throughput 8. Ensure adherence to data governance policies and best practices, maintaining data integrity and security throughout the lifecycle Required Skills: 1. Informatica MDM 2. ETL pipeline development with Informatica 3. Advanced SQL programming 4. Python for data engineering 5. Enterprise data warehousing 6. Data modeling for large-scale systems 7. PLSQL 8. T-SQL 9. Stored procedures development Preferred Skills: 1. Experience with cloud-based ETL tools such as Azure Data Factory or AWS Glue 2. Expertise in master data management platforms beyond Informatica 3. Knowledge of big data technologies such as Spark or Hadoop 4. Familiarity with data governance frameworks 5. Proficiency in performance tuning and optimization of ETL processes Desired Qualifications: 1. Bachelor’s degree in Computer Science, Information Technology, or a related field 2. Relevant certifications in Informatica MDM or ETL technologies Additional Information: Informatica MDM skills are required as a core competency for this role.