Required Skills Experience in Datastage 11.7.x and in Linux scripting. Experience in Kettle. Experience in DB2 and SQL Server. Ability to write complex SQL queries. Proficiency in java script and HTML is required. Experience in Cognos 11.x and Tableau preferred. Experience with R or Python is preferred Well Versed in different development methodologies (Iterative, Agile, Scrum etc.). Self learner with ability to work with new technologies. Strong interpersonal skills and ability to work well in a team. Self-motivated with ability to work with minimal supervision.
Job Responsibilities:
- 8+ years of experience in ETL development and providing production support for existing datafeeds.
- Perform development and design activities for ETL & Data Integration, Query Optimization as well as supports UAT process and participates in System Integration testing.
- Develop ETL jobs for data exchanges within the agency databases and data warehouse, across agencies, vendor data feeds and DOITT open data.
- Provide production support for existing ETL jobs.
- Create technical design documents and mentor Junior ETL Developer (s).
- Contribute to the evolution of the system's architecture and technology, as well as the continual improvement of development processes. Ensures that defined architecture, coding standards and best practices are followed.
- Experience working as part of a large-scale enterprise IT organization supporting mission critical applications.
- Excellent problem-solving skills and attention to detail.
- Ability to interact effectively with stakeholders, technical staff, operations managers, project managers.
- Mentor other team members and share knowledge with others.
- Strong and articulate verbal and written communication skills.