What are the responsibilities and job description for the ETL Developer position at BuzzClan?
Only Apply Local to Arizona Candidate.
Position: ETL Developer
Employment Type: Contract
Location: 5850 W Glendale Ave, Glendale, AZ, 85301
Work Arrangement: - Overview (Onsite)
The Client is seeking an experienced ETL Developer to design, develop, and support data integration solutions across both on-premises and cloud environments. The ideal candidate will have strong hands-on expertise with Informatica and a solid working knowledge of the Microsoft data stack (SQL Server, Azure Data Factory, SSIS, or related tools). This role requires someone comfortable supporting hybrid infrastructure and collaborating with cross-functional teams to ensure reliable, high-performing data pipelines.
Key Responsibilities
- Design, develop, test, and maintain ETL workflows using Informatica PowerCenter/IICS (or equivalent Informatica tools)
- Build and support data integration processes across on-premises and cloud (Azure) environments
- Develop, optimize, and maintain SQL queries, stored procedures, and data transformation logic within the Microsoft SQL Server ecosystem
- Monitor, troubleshoot, and resolve ETL job failures, performance bottlenecks, and data quality issues
- Collaborate with data architects, DBAs, and business stakeholders to gather requirements and translate them into technical ETL designs
- Support data migration and modernization initiatives, including on-prem to cloud transitions
- Implement and maintain data governance, security, and compliance standards for municipal data
- Create and maintain technical documentation for ETL processes, data flows, and mappings
- Participate in on-call/production support rotations as needed
- Work with scheduling tools to automate and monitor batch ETL jobs
Required Qualifications
- 7 years of hands-on experience as an ETL Developer
- Strong expertise in Informatica (PowerCenter, IICS, or Informatica Cloud)
- Proven experience supporting both on-premises and cloud-based data environments
- Solid experience with the Microsoft technology stack — SQL Server, T-SQL, SSIS, and/or Azure Data Factory
- Strong SQL scripting and query optimization skills
- Experience with data warehousing concepts (star schema, dimensional modeling, etc.)
- Familiarity with Azure cloud services (Azure SQL, Azure Data Lake, Azure Synapse — nice to have)
- Strong analytical and troubleshooting skills
- Excellent communication skills, with ability to work directly with government/municipal stakeholders
- Prior experience working with government/public sector clients or agencies (city, county, state, or federal) is required
Preferred Qualifications
- Experience working with government or public sector clients
- Familiarity with data governance and compliance requirements in municipal IT environments
- Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Azure equivalents)
- Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience)
Soft Skills
- Strong problem-solving and analytical mindset
- Ability to work independently and manage priorities in a fast-paced environment
- Strong documentation and stakeholder communication skills