Total-TECH Co.
” The Job Description”
- Design and implement data ingestion pipelines and ETL processes using SSIS, Informatica BDM,or native tools to meet functional and non-functional business requirements.
- Create and manage data workflows in orchestration tools such as Control-M to ensure scalability, optimize data delivery, and automate manual processes.
- Ensure data quality, integrity, and consistency across all systems, enabling trusted data for decision-making.
- Develop complex T-SQL and PL/SQL queries, stored procedures, and scripts for data transformation and integration.
- Monitor performance and recommend configuration or infrastructure changes to improve efficiency and reliability.
- Troubleshoot and resolve high-impact data issues through in-depth analysis of business and system processes.
- Design logical and physical data models to support enterprise data architecture.
- Establish and enforce standards for coding, testing, debugging, and implementation of ETL solutions.
- Collaborate with stakeholders across multiple functions to understand business processes and data requirements.
- Support enterprise ETL and BI developers in development and troubleshooting data-related issues; advise on efficient data extraction for reporting and analytics.
Requirements:
- 8–10 years of experience in ETL development and data engineering, preferably with SSIS, Informatica BDM,SSAS, SQL Server, Oracle, and semi/unstructured data.
- l Proven experience in solution engineering, data modeling, and operations.
- l Hands-on experience with orchestration tools (e.g., Control-M) and data quality frameworks.
- l Familiarity with Hadoop distributions (Cloudera, MapR, Hortonworks) is a plus.
- l Strong T-SQL and PL/SQL skills; ability to optimize and tune queries and ETL jobs.
Technical Skills:
- ETL Tools: SSIS, Informatica BDM.
- Databases: SQL Server, Oracle, Vertica, NoSQL.
- Data Modeling: Logical and physical modeling.
- Big Data & Cloud: Cloudera, Azure, Snowflake, HDFS, Spark.
- BI Tools: Microsoft Power BI, IBM Cognos.
Soft Skills:
- Strong analytical and problem-solving abilities.
- Excellent communication and collaboration skills.
- Ability to work in a fast-paced environment and manage multiple priorities.
- Proactive ownership mindset with attention to detail and documentation.
Preferred Certifications (Optional)
- Microsoft Certified: Azure Data Engineer Associate.
- Informatica Cloud/BDM Professional.