Lead ETL Engineer

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