What are the responsibilities and job description for the ETL Developer (Informatica\DataStage) position at Envision Technology Solutions?
Role: ETL Developer (Informatica\DataStage)
Location: Charlotte, NC
Job Description
Must Have Technical/Functional Skills
Primary Skill: ETL
Secondary: Informatica\DataStage
Experience: Between 8 to 20 years
Roles & Responsibilities
- As an Data Engineer, candidate will be expected to craft data solutions to meet business and enterprise requirements using Informatica/DataStage SQL, Python and ETL Tools to enhance and support a Data Warehouse.
- Strong SQL skills and awareness / experience of good coding practices and ability to articulate such.
- Practical working experience with relational databases, preferably Oracle Exadata.
- Familiarity with Data Warehouse / Data Mart / Data Modeling / Business Intelligence concepts.
- Familiarity with Autosys / Orchestration Tools.
- Exposure / self-education with Unix scripting.
- Exposure / self-education with Python (e.g. Pandas, Data Frames) and use in data processing solutions.
- Exposure to CI/CD processes and tools (e.g. Ansible, Jenkins).
- Experience designing and building data warehouses and knowledge of the data flows involved.
- Willingness to take on problems outside of current skillset and experience.
- Experience with development methodologies and working in an agile framework.