IT Developer Analyst I

Alight - Indianapolis, IN

Full-time - Mid Level

Indianapolis, IN

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

The ETL Developer at Alight is responsible for various stages of software development, focusing on delivering high-quality enterprise systems using Informatica PowerCenter. This role involves understanding business requirements, coding, testing, documentation, deployment, and production support, with a primary focus on data integration projects.

Responsibilities

• Design software solutions for small to medium complexity requirements independently, adhering to existing standards.
• Develop high-priority and highly complex code for systems based on functional specifications, detailed design, maintainability, and coding and efficiency standards, working independently.
• Estimate and evaluate risks, and prioritize technical tasks based on requirements.
• Collaborate actively with ETL Lead, Product Owners, Quality Assurance, and stakeholders to ensure high-quality project delivery.
• Conduct formal code reviews to ensure compliance with standards.
• Utilize appropriately system design, development, and process standards.
• Write and execute unit test cases to verify basic functionality, both for your own code and that of your peers.
• Create, maintain, and publish system-level documentation, including system diagrams, with minimal guidance.
• Ensure clarity, conciseness, and completeness of requirements before starting development, collaborating with Business Analysts and stakeholders to evaluate feasibility.

Requirements

• 5+ years of data integration, data warehousing, or data conversion experience.
• 3+ years of SQL writing and optimization experience.
• 3+ years of Informatica PowerCenter experience.
• 1.5+ years working with Microsoft SQL Server Management Studio.
• Experience with XML file data integration.
• Experience with UNIX shell scripting.
• Strong understanding of using ETL tools to integrate internal and third-party systems.
• Excellent analytical and critical thinking skills.
• Strong interpersonal skills with the ability to work effectively with diverse and remote teams.
• Experience in agile processes and development task estimation.
• Strong sense of responsibility for deliverables.
• Ability to work in a small team with moderate supervision.

Nice-to-haves

• Experience with Microsoft Dynamics or other CRM system preferred.

Benefits

• Variety of health coverage options
• Wellbeing and support programs
• Retirement plans
• Vacation and sick leave
• Maternity, paternity & adoption leave
• Continuing education and training
• Voluntary benefit options