ETL Developer
Accenture
Role Overview:
We are looking for a motivated and detail-oriented ETL Developer to join our custom software engineering team. In this role, you will be responsible for designing and developing robust ETL processes to support enterprise data integration needs. You will collaborate closely with functional analysts to interpret business requirements and translate them into scalable, well-documented technical specifications.
This role also involves active participation in User Acceptance Testing (UAT), including investigating and resolving bugs, and ensuring the smooth deployment of solutions to production environments.
The ideal candidate will have hands-on experience with Informatica PowerCenter and Microsoft SQL Server, along with a working knowledge of CRM systems. While direct experience with Siebel CRM is a strong plus, familiarity with similar platforms (e.g., Salesforce, Dynamics 365) is equally valued.
Key Responsibilities:
- Analyze functional requirements and translate them into technical specifications for ETL implementation.
- Design, develop, and optimize ETL workflows using Informatica to extract and transform data from CRM systems and other sources.
- Prepare and maintain technical documentation for data mappings, transformation logic, and job schedules.
- Support User Acceptance Testing (UAT) by investigating and resolving bugs or data issues identified by clients.
- Monitor and troubleshoot ETL jobs, ensuring performance and reliability.
- Participate in post-UAT deployment activities and ensure smooth transition to production.
Required Qualifications, Skills & Experience:
- Bachelor’s degree in computer science/software engineering, or any related courses.
- 2+ years of experience in ETL development, preferably with Informatica PowerCenter.
- Proficiency in SQL, with hands-on experience in Microsoft SQL Server (MSSQL).
- Basic understanding of CRM data models and common integration patterns (e.g., Siebel, Salesforce, Dynamics 365, or similar).
- Experience with data profiling, cleansing, and transformation techniques.
- Familiarity with data warehousing concepts and dimensional modeling.
- Knowledge in java would be an advantage.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
About Accenture
We work with one shared purpose: to deliver on the promise of technology and human ingenuity. Every day, more than 775,000 of us help our stakeholders continuously reinvent. Together, we drive positive change and deliver value to our clients, partners, shareholders, communities, and each other.We believe that delivering value requires innovation, and innovation thrives in an inclusive and diverse environment. We actively foster a workplace free from bias, where everyone feels a sense of belonging and is respected and empowered to do their best work.At Accenture, we see well-being holistically, supporting our people’s physical, mental, and financial health. We also provide opportunities to keep skills relevant through certifications, learning, and diverse work experiences. We’re proud to be consistently recognized as one of the World’s Best Workplaces™.Join Accenture to work at the heart of change.Visit us at www.accenture.com
Equal Employment Opportunity Statement
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.
Accenture is committed to providing veteran employment opportunities to our service men and women.