Cloud Hybrid Technologies, LLC
Informatica Developer Data Warehousing & ETL
Cloud Hybrid Technologies, LLC, Virginia, Minnesota, United States, 55792
Overview
Informatica Developer Data Warehousing & ETL Location: Duration: 12Months + Extension Hourly Rate: Depending on Experience (DOE) Work Authorization: Title -Informatica Developer Data Warehousing & ETL, Alteryx What You ll Bring with You
8+ years of experience as an Informatica Developer in enterprise data warehouse environments. Strong expertise in SQL (Oracle, SQL Server, PostgreSQL, or similar), including performance tuning. Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling, star/snowflake schemas). Hands-on experience in data loading techniques (incremental loads, CDC, batch, streaming). Strong knowledge of data comparison and reconciliation mechanisms for validating large data sets. Experience with ETL performance optimization and error handling. Familiarity with cloud data platforms (AWS Redshift, Snowflake, Azure Synapse, or Google Cloud Platform BigQuery) is a plus. Strong problem-solving and debugging skills for ETL and data issues. Ability to work in Agile teams, collaborating with business and technical stakeholders. Excellent communication skills with the ability to explain technical solutions to non-technical users. Responsibilities
Design, develop, and maintain ETL workflows using Informatica PowerCenter/Cloud to support enterprise data integration needs. Implement data loading strategies for large-scale structured and semi-structured data. Develop efficient SQL queries, stored procedures, and performance tuning for optimal data processing. Work with data warehouse concepts (fact tables, dimension tables, star/snowflake schemas, slowly changing dimensions, partitioning, indexing). Design and implement data comparison and reconciliation mechanisms to ensure data quality and consistency across systems. Collaborate with data architects, analysts, and business teams to gather requirements and translate them into technical ETL solutions. Perform data profiling, cleansing, and validation to support business reporting and analytics. Optimize ETL pipelines for scalability, performance, and reliability. Participate in code reviews, debugging, and production support for ETL processes. Work with version control, CI/CD, and scheduling tools for deployment and automation of data workflows. Benefits / Equal Opportunity
Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract
#J-18808-Ljbffr
Informatica Developer Data Warehousing & ETL Location: Duration: 12Months + Extension Hourly Rate: Depending on Experience (DOE) Work Authorization: Title -Informatica Developer Data Warehousing & ETL, Alteryx What You ll Bring with You
8+ years of experience as an Informatica Developer in enterprise data warehouse environments. Strong expertise in SQL (Oracle, SQL Server, PostgreSQL, or similar), including performance tuning. Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling, star/snowflake schemas). Hands-on experience in data loading techniques (incremental loads, CDC, batch, streaming). Strong knowledge of data comparison and reconciliation mechanisms for validating large data sets. Experience with ETL performance optimization and error handling. Familiarity with cloud data platforms (AWS Redshift, Snowflake, Azure Synapse, or Google Cloud Platform BigQuery) is a plus. Strong problem-solving and debugging skills for ETL and data issues. Ability to work in Agile teams, collaborating with business and technical stakeholders. Excellent communication skills with the ability to explain technical solutions to non-technical users. Responsibilities
Design, develop, and maintain ETL workflows using Informatica PowerCenter/Cloud to support enterprise data integration needs. Implement data loading strategies for large-scale structured and semi-structured data. Develop efficient SQL queries, stored procedures, and performance tuning for optimal data processing. Work with data warehouse concepts (fact tables, dimension tables, star/snowflake schemas, slowly changing dimensions, partitioning, indexing). Design and implement data comparison and reconciliation mechanisms to ensure data quality and consistency across systems. Collaborate with data architects, analysts, and business teams to gather requirements and translate them into technical ETL solutions. Perform data profiling, cleansing, and validation to support business reporting and analytics. Optimize ETL pipelines for scalability, performance, and reliability. Participate in code reviews, debugging, and production support for ETL processes. Work with version control, CI/CD, and scheduling tools for deployment and automation of data workflows. Benefits / Equal Opportunity
Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract
#J-18808-Ljbffr