ETL DataStage Developer

Amtex Systems Inc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 20 years. Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest. Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements; Assist in the collection of technical metadata supporting the implementation; Utilize automation tools to schedule, execute, and monitor ETL jobs; Design, test, and debug data flow plans to create necessary Client files and/or populated databases; Design of the ETL application; Performance tune the application to meet operational production requirements; Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system and integration test plans; Responsible for data migration from legacy system to new Platform Design and develop ETL jobs and sequences Design and develop multiple reports including audit, error and reconciliation reports. Candidate must have understanding of ETL Processes and Best Practices Expert level knowledge and hands-on experience with IBM DataStage Enterprise Edition/Parallel Extender (Orchestrate) for parallel processing as part of ETL conversion process integrating multiple source Required Skills: Integration of various data sources like Oracle, DB2, DB2UDB, SQL Server, API's and Flat files into the target tables. SQL, PL/SQL Performance Tuning of SQL statements, stored procedures and functions. Writing UNIX shell scripts as per the requirement and used Job scheduling tools like Autosys utility Firm understanding of software development Lifecycle, release management and change management process 5+ years of experience in Production Support. Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment. Strong written and verbal communication skills Understanding and hands-on experience with XML packages in DataStage Diverse understanding of IT infrastructure and other technologies is a plus Strong written and verbal communication skills Team player and self-motivated, work independently with minimum direction Desired Skills: Apache Nifi & Confluent Kafka Fundamental knowledge of IT Service Management/ITIL processes and tools Data Virtualization using Presto/Trino Experience with Jira & Bitbucket Autosys and Oozie