The Role
Lead design and implement ETL pipelines using Informatica MDM, develop and optimize complex SQL/PLSQL/T-SQL stored procedures, model enterprise data warehouses, automate ingestion with Python, troubleshoot ETL performance, enforce data governance, and collaborate with cross-functional teams to ensure data quality and scalable modern data platform architectures.
Summary Generated by Built In
Lead Data Engineer
Primary Skills
- ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
- ETL Specialization: Data Engineer
Job requirements
- 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.
Skills Required
- 4 to 6 years of experience with hands-on ETL and Informatica MDM
- Informatica MDM
- ETL pipeline development with Informatica
- Advanced SQL programming
- PLSQL
- T-SQL
- Stored procedures development
- Python for data engineering and automation
- Enterprise data warehousing experience
- Data modeling for large-scale systems
- Knowledge of data governance policies and best practices
- Bachelor's degree in Computer Science, Information Technology, or related field
- Relevant certifications in Informatica MDM or ETL technologies
- Experience with cloud-based ETL tools such as Azure Data Factory or AWS Glue
- Knowledge of big data technologies such as Spark or Hadoop
- Experience with performance tuning and optimization of ETL processes
Brillio Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.
-
Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
-
Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
-
Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.
Brillio Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.
