Sr Data Specialist - R01568425
Skilyrði:PythonAWSAzureCloudDataSecurityLead
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:
- Design and implement robust ETL pipelines using Informatica MDM to ensure accurate data integration and management across enterprise systems
- Develop, optimize, and maintain complex SQL, PLSQL, and T-SQL stored procedures for efficient data processing and transformation
- Lead data modeling initiatives, translating business requirements into scalable data warehouse solutions and modern data platform architectures
- Collaborate with cross-functional teams to gather requirements, validate data quality, and deliver actionable insights through advanced data engineering practices
- Troubleshoot and resolve data-related issues, ensuring high availability, reliability, and performance of ETL workflows
- Automate data ingestion and transformation tasks using Python, enhancing operational efficiency and reducing manual intervention
- Monitor and improve ETL performance, proactively identifying bottlenecks and implementing enhancements to achieve optimal throughput
- Ensure adherence to data governance policies and best practices, maintaining data integrity and security throughout the lifecycle
Required Skills:
- Informatica MDM
- ETL pipeline development with Informatica
- Advanced SQL programming
- Python for data engineering
- Enterprise data warehousing
- Data modeling for large-scale systems
- PLSQL
- T-SQL
- Stored procedures development
Preferred Skills:
- Experience with cloud-based ETL tools such as Azure Data Factory or AWS Glue
- Expertise in master data management platforms beyond Informatica
- Knowledge of big data technologies such as Spark or Hadoop
- Familiarity with data governance frameworks
- Proficiency in performance tuning and optimization of ETL processes
Desired Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Relevant certifications in Informatica MDM or ETL technologies
Additional Information:
Informatica MDM skills are required as a core competency for this role.