Title: ETL Developer
Duration: 15 Months (+ Extension)
Location: Austin, TX
Client: Accenture/TMHP
Job Responsibilities:
Responsibilities:
- ETL Developers build and maintain the extract, transformation and load (ETL) processes for Medicaid’s data and analytics systems.
- This role functions as a member of an Agile Scrum development team that relies up teamwork, technical skills, and business acumen.
- ETL Developers primarily use Informatica PowerCenter to develop and test solutions.
- Yet, projects often demand a diverse set of skills needed to improve a complex mix of new and legacy systems.
General Responsibilities
- Complete analysis, design, code, testing and deployment tasks for ETL programs and reports within approved estimates
- Test system data validations and mappings using Informatica Data Validation Option (DVO) and SQL
- Effectively participate in Agile Scrum meetings
- Document work items and testing in Microsoft TFS
- Combine technical skills with Texas Medicaid business and system knowledge to deliver effective solutions
- Produce work products that demonstrate quality, efficiency, and effective use of standards and procedures
- Provide timely status on assignments in a clear and concise manner
- Escalate risks and issues with sufficient lead time to avert crises
- Participate in on-call support as well as after-hour deployments of production releases
- Communicate effectively with stakeholders and team members
- Help identify and implement continuous improvement opportunities
- Track work hours in an accurate and timely manner
- Proactively complete all compliance training courses in a timely manner
ETL Developer Skills
Required Skills
- 2+ years – Developing and supporting ETL/ELT solutions
- 2+ years – Developing data warehouse, business intelligence, and/or data analytics systems
- 2+ years – ETL development experience (Informatica, BO DS, or similar)
- 2+ years – SQL development experience
- 1+ years – Database development experience (Oracle, SQL Server, or similar)
- 1+ years – Agile Scrum experience
Preferred Skills
- Broader Informatica product suite experience including Informatica Data Validation Option, Informatica Data Quality, and Test Manager
- Oracle PL-SQL development experience
- SAP Business Intelligence BusinessObjects development experience
- SAP Data Services development experience
- Medicaid business and systems knowledge
main duties/responsibilities
- ETL Developers build and maintain the extract, transformation and load (ETL) processes for Medicaid’s data and analytics systems.
- This role functions as a member of an Agile Scrum development team that relies up teamwork, technical skills, and business acumen.
- ETL Developers primarily use Informatica PowerCenter to develop and test solutions.
- Yet, projects often demand a diverse set of skills needed to improve a complex mix of new and legacy systems.
Must -have:
1. ETL (Informatica, SAP BO DS, or similar)
2. SQL
3. Data warehouse
Nice to Have:
1. BI Reporting (Business Objects or similar)
2. Healthcare/Medicaid 3. Oracle
Thanks,
Praveen Kumar S | Thoughtwave, Inc
1444 N. Farnsworth Ave, Suite 302, Aurora, IL - 60505
praveen@thoughtwavesoft.com
Direct: 630 506 5579 / 630 448 6681 Ext: 126| Fax: 630-689-5746