” 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.
Required Qualifications:
8–10 years of experience in ETL development and data engineering, preferably with SSIS, Informatica BDM,
SSAS, SQL Server, Oracle, and semi/unstructured data.
Proven experience in solution engineering, data modeling, and operations.
Hands-on experience with orchestration tools (e.g., Control-M) and data quality frameworks.
Familiarity with Hadoop distributions (Cloudera, MapR, Hortonworks) is a plus.
Strong T-SQL and PL/SQL skills; ability to optimize and tune queries and ETL jobs.
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.
Preferred Certifications (Optional):
Microsoft Certified: Azure Data Engineer Associate.
Informatica Cloud/BDM Professional.
Tagged as: azure, ETL, hdfs, IBM, informatica bdm, oracle, PL, power bi., snowflake, SQL, ssis, t-sql, vertica
