Job Description
Design, develop, enhance, and support ETL workflows within a large-scale enterprise data warehouse.
Build and maintain Informatica Cloud Data Integration for PowerCenter (CDI-PC) pipelines.
Support regulatory reporting processes that rely on accurate, timely, and high-quality data delivery.
Integrate data from multiple source systems including Oracle, DB2, SQL Server, Sybase, and other relational databases.
Develop, troubleshoot, and optimize complex SQL queries involving large datasets and multi-table joins.
Analyze warehouse data models including fact tables, dimension tables, indexes, views, and relationships.
Create and maintain shell scripts supporting ETL execution and data movement processes.
Participate in Agile/Scrum ceremonies, development planning, and production support activities.
Investigate data quality issues and perform root cause analysis across source systems and ETL workflows.
Support data reconciliation and validation activities using Alteryx and Python-based processes.
Collaborate with team members in both the U.S. and India to support ongoing platform modernization initiatives.
Contribute to future-state architecture efforts involving AWS S3 and modern cloud data frameworks.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
Experience with Altreyx
AWS experience
Nice to Have Skills & Experience
8+ years of Informatica development experience.
PowerCenter and Informatica Cloud Data Integration for PowerCenter (CDI-PC).
Strong Oracle database experience.
Advanced SQL development skills including: (Complex joins across 10+ tables, Query tuning and optimization, Data manipulation and transformation, Views, indexes, and database performance concepts)
Experience working within enterprise data warehouse environments.
Strong understanding of Fact and dimension modeling, Data warehouse design concepts, Relational database structures
Experience with Unix/Linux shell scripting.
Experience supporting production ETL jobs and troubleshooting data issues.
Strong communication skills and ability to work within a distributed global team.
Basic knowledge of Python (or Altreyx)
Hands on experience using AI
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.