eTeam
Positions - Lead ETL Engineer
Location - Denver, CO (100% Remote)
Duration - 6 months
Seeking a candidate with extensive Informatica PowerCenter/IICS development experience and strong hands-on expertise in SQL queries and performance tuning.
10-15 years of hands-on experience with Informatica PowerCenter for designing and implementing complex ETL workflows. 8+ years in data modeling (conceptual, logical, and physical) for data warehousing, analytics solutions. 7+ years of experience as a Data Analyst, performing advanced data profiling, analysis, and reporting to support strategic decision-making. 5+ years of experience with Informatica Intelligent Cloud Services (IICS) for cloud-based data integration and orchestration. 5+ years of hands-on experience with Amazon Redshift, including advanced schema design, query optimization, and large-scale data management. 5+ years of hands-on experience with Python for data processing, automation, and integration with ETL, data warehousing, and analytics platforms. Expert-level proficiency in Informatica PowerCenter and IICS for ETL and cloud-native data integration. Advanced SQL skills for querying, optimizing, and managing Amazon Redshift environments, including expertise in Redshift-specific features. Strong expertise in data modeling tools (e.g., ER/Studio, Erwin, or Data Vault) and advanced modeling techniques (e.g., star/snowflake schemas, graph-based models). Proficiency in Python for data manipulation, automation, and analytics (e.g., pandas, NumPy, PySpark, Airflow). Experience with data visualization and analytics platforms (e.g.,MSTR, Power BI) for delivering actionable insights. Familiarity with AWS cloud services (e.g., S3, Glue, Lambda, SageMaker) and DevOps tools (e.g., Jenkins, Git) for data pipeline automation
Seeking a candidate with extensive Informatica PowerCenter/IICS development experience and strong hands-on expertise in SQL queries and performance tuning.
10-15 years of hands-on experience with Informatica PowerCenter for designing and implementing complex ETL workflows. 8+ years in data modeling (conceptual, logical, and physical) for data warehousing, analytics solutions. 7+ years of experience as a Data Analyst, performing advanced data profiling, analysis, and reporting to support strategic decision-making. 5+ years of experience with Informatica Intelligent Cloud Services (IICS) for cloud-based data integration and orchestration. 5+ years of hands-on experience with Amazon Redshift, including advanced schema design, query optimization, and large-scale data management. 5+ years of hands-on experience with Python for data processing, automation, and integration with ETL, data warehousing, and analytics platforms. Expert-level proficiency in Informatica PowerCenter and IICS for ETL and cloud-native data integration. Advanced SQL skills for querying, optimizing, and managing Amazon Redshift environments, including expertise in Redshift-specific features. Strong expertise in data modeling tools (e.g., ER/Studio, Erwin, or Data Vault) and advanced modeling techniques (e.g., star/snowflake schemas, graph-based models). Proficiency in Python for data manipulation, automation, and analytics (e.g., pandas, NumPy, PySpark, Airflow). Experience with data visualization and analytics platforms (e.g.,MSTR, Power BI) for delivering actionable insights. Familiarity with AWS cloud services (e.g., S3, Glue, Lambda, SageMaker) and DevOps tools (e.g., Jenkins, Git) for data pipeline automation