KAYConnect LLC · 14 hours ago
Informatica PowerCenter Business Intelligence Developer - Multiple locations - Kansas City, MO / Milwaukee, WI / Wellesley, MA
Wellesley, MA
Contract
Hybrid
Mid Level
$55/hr - $55/hrKAYConnect LLC is seeking an Informatica PowerCenter Business Intelligence Developer to design, develop, and optimize ETL pipelines. The role involves building scalable data pipelines, ensuring data quality, and collaborating with stakeholders to meet reporting and analytics needs.
Information Technology & Services
Responsibilities
Design, develop, and optimize ETL pipelines using Informatica PowerCenter and Informatica Cloud (IICS)
Build and maintain scalable data pipelines (80% development-focused role)
Ensure data quality, consistency, accuracy, and compliance across multiple systems
Develop and optimize complex SQL queries, stored procedures, MDX, and DAX
Perform ETL and SQL performance tuning for large datasets
Design and support data models, semantic layers, and metadata for reporting and self-service analytics
Collaborate with business stakeholders to translate reporting and analytics needs into technical solutions
Support Tier 2–4 BI production issues and troubleshoot data-related problems
Develop and enhance reports, dashboards, and scorecards using BI tools
Participate in discovery and design phases of small to medium BI projects
Execute Proof of Concepts (POCs) for new tools and technologies
Ensure data accuracy and support testing and certification activities
Work in a collaborative Agile team environment with product owners, analysts, and vendors
Qualification
Required
Informatica PowerCenter (mandatory)
Informatica Cloud (IICS)
SSIS
Informatica Data Quality (IDQ)
Metadata Manager
Advanced SQL (complex queries, performance tuning, stored procedures)
Experience with Oracle
SQL Server
PostgreSQL
MySQL
Strong understanding of data warehousing concepts (Star/Snowflake schemas, fact & dimension modeling)
Azure (Synapse Analytics, Data Factory, Blob Storage preferred)
AWS (S3, Redshift, Glue, Lambda – acceptable alternative)
Dimensional modeling
Snowflake
Databricks
Redshift
Delta Lake
Apache Iceberg
Performance Optimization: ETL job tuning, SQL optimization for large data volumes
Data Quality & Governance: Validation, cleansing, transformation, security, and compliance
Problem Solving: Troubleshooting complex ETL, SQL, and data pipeline issues
Communication: Ability to explain technical concepts to non-technical stakeholders
Adaptability: Willingness to learn and work across evolving cloud and BI technologies
Preferred
Power BI
Tableau
SSRS
Cognos
Qlik
Looker
Python
PySpark
Pandas
dbt
Shell scripting
Spark
Airflow
Kafka
Airbyte
Stitch
Collibra
Alation
Informatica IDQ
MDM
Benefits
Flexible hybrid/remote work options
Collaborative and innovative team environment
Company
KAYConnect LLC
As your premier staffing and solutions provider, KAYConnect is reshaping the standards of excellence in staffing and solutions.
Founded in 2023
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase