80% Remote in NY/NJ/CA/PA areas only with local DL
• Must be from local NYC/NJ banking or finance companies (mid-sized preferred: No Bank of America; No Citibank; midsized banking or financial services firms in the local area
• Must have smiling face on LinkedIN profile that 100% matches the resume (don’t send if they years of creation do not match year of resume)
• Must live in New Jersey or New York or Connecticut or Pennsylvania with valid state drivers license in the home they live now
• Resume must reflect the projects and the scope of them; don’t send a list of tasks. We need developers who can explain what they do clearly.
• no junior people
The ETL Developer is part of the Data Analytics team group is responsible for designing, building, deploying, supporting and maintaining ETL A2A DataStage interfaces using the IBM InfoSphere DataStage ETL development tool. The ETL Developer will be main DataStage ETL interfaces and will designs, develops, maintains, and supports DataStage ETL compliance processes using the IBM InfoSphere DataStage tool. This role is also responsible for complex interface process development, troubleshooting issues, supporting weekend maintenance and production support of the interface processes development by the ETL Team. Reports to the Team Leader. Has no direct/indirect reports.
Takes full ownership of one or more projects primarily focused on developing integration solutions for multiple projects. This role executes deliverables with minimal supervision applying standard operating procedures as well as technical expertise to unique sets of facts, refers more complex matters to supervisors or other experienced staff. This role participates in a production weekly support roster.
NOTE: Top three skills
- Expert experience implementing and supporting large data warehouse/data mart, using Datastage ETL tool.
- Functional experience using data model as the main document to design and develop the Datastage load process for a data warehouse/data mart
- Experience developing both server and parallel jobs running on a Unix platform against relational databases (i.e., Oracle or SQL Server systems) as source and target data environment
The job responsibilities are described herein:
- Performs analysis and design of the business requirements and specifications as required.
- Develops and maintains interface ETL processes between databases and/or flat files.
- Works with various application team members to obtain the requirements for their development work.
- Creates unit test plans and performs unit testing for the interface processes that they developed or modified.
- Creates documentation for the processes that they developed as well as updates documentation for the processes that they modified.
- Performs peer code reviews including verification of compliance with coding standards and ensures that the code they developed adheres to coding standards and functional / technical specifications.
- Coordinates code promotion activities through all SDLC environments and validates that promoted interface code is working as expected.
- Assists QA team with identifying QA test cases and supports them during QA testing.
- Updates team leader and project manager with status of assigned development/project work.
- Troubleshoots production issues independently and assists in timely resolution of incidents.
- ETL Support. Supports weekend maintenance, technology / business recovery tests and system verification / validation events.
- Keeps up to date on new features and enhancements in the development tools used by the team.
CRITICAL JOB KNOWLEDGE AND CORE COMPETENCIES/SKILLS
- Expert experience implementing and supporting large data warehouse/data mart, using Datastage ETL tool.
- Functional experience using data model as the main document to design and develop the Datastage load process for a data warehouse/data mart.
- Strong knowledge of relational and dimensional database concepts.
- Experience working in all phases of a full project life cycle, including design.
- Experience developing both server and parallel jobs running on a Unix platform against relational databases (i.e., Oracle or SQL Server systems) as source and target data environment.
- Expert understanding of data warehouse concepts and experience implementing data warehouse.
- Demonstrate ability to work on multiple projects simultaneously.
- Excellent communication skills both verbal and written with the ability to write and communicate requirements to business and technology partners.