ETL Specialist (DataStage / SQL / Oracle)

Trigyn's direct government client has an immediate need for an ETL Specialist in Albany, NY.

Description:
? Ensuring application documentation is complete, organized, accessible, and follows office standards.
? Writing, testing, debugging new and existing code based on program area knowledge, conceptual and technical design specifications.
? Write and test procedures, parameters and other specifications required to implement programs.
? Develop or assist with the development of unit, component and program test plans.
? Implement program changes and provide user support as required.
? Data Warehouse design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Fraud Detection/Improper Payment algorithms;
? Develop, test and implement program logic for data mining and ETL development;
? Implement ETL technical specifications from development through test, staging and production environments;
? Optimize ETL data load jobs to improve performance and automate;
? Investigating and resolving data loading and/or data integrity issues;
? Create solutions to improve system performance and availability;
? Develop and maintain logical and physical dimensional data models for data warehouse/data mart;
? Write clear documentation of process and data modeling and all associated tasks and documents including unit and quality assurance test plans.

Mandatory Qualifications:
? Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
? Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

? 72 Months ETL development experience in Oracle environment with IBM DataStage
? 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming
? 84 Months experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries
? 84 Months UNIX Shell Scripting experience
? 60 months experience in programming and unit testing.
? 60 months experience in program code documentation, mentoring and assisting other developers.
? 60 months experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) for production system error diagnosis, debugging, and code modification
? 84 Months experience developing dimensional data models for Cognos data analytics
? 84 Months experience developing data analysis and metrics queries for operational oversight.
? 84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for Stop/start services; monitor logs; setting up security; assigning roles; project permissions; Create/Delete projects; create/modify environmental parameters; Platform Issue resolution; troubleshooting and root cause analysis; Configuration and tuning of production and lower-level environments; and capacity planning.

For Immediate Response call , or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.