Job Description

Reference # : 19-00762Title : ETL Developer
Location : Irving, NJ
Position Type : Contract
Experience Level : Start Date : 08/22/2019
Our client, a leading global financial services company, has approximately 200 million customer accounts and does business in more than 140 countries. They provide consumers, corporations, governments and institutions with financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.

Key Responsibilities:

The key responsibilities for the candidate are:
- Develop and design highly efficient ETL solutions based on the business requirements and aggressive delivery timelines
- Understanding Business and Functional Requirements provided by Business Analysts and to convert into Technical Design Documents to deliver on the requirements
- Ensure best practices are followed
- Prepare detailed level test plans and ensure proper testing for each module developed
- Prepare handover documents; manage SIT with oversight of UAT and Production Implementation
- Identify and proactively resolve issues that could affect system performance, reliability, and usability
- Demonstrates an in-depth understanding of how the development function integrates within overall business/technology to achieve objectives; requires a good understanding of the industry
- Ensure process compliance and manage expectations of the leadership
- Work proactively & independently to address development requirements and articulate issues/challenges with enough lead time to address risks
- Design, Implement, Integrate and test new features
- Explore existing application systems, determines areas of complexity, potential risks to successful implementation
- Ability to build relationship with business and technology stakeholders
- Successfully migrate ETL logic into Spark/Hadoop platform

- 8 to 10 years of experience in Software development
- Expertise in building ETL applications using Ab Initio, Data Stage, Talend or ACE
- Good knowledge of RDBMS – Oracle, with ability to write complex SQL needed to investigate and analyze data issues
- 2+ years of experience in big data ecosystem Hadoop, Spark & Hive will be strong plus
- Good in UNIX shell scripting
- Hands on experience in Autosys /Control Centre scheduling tools
- Proven 3+ years of experience in working with complex data warehouses
- Strong influencing & interpersonal skills
- Willing to work flexible hours

- Strong design and execution bend of mind
- Candidate should possess a strong work ethic, good interpersonal, communication skills, and a high energy level
- Candidate should share many common traits: Analytical thinker, quick learner who is capable of organizing and structuring information effectively;
- Ability to prioritize and manage schedules under tight, fixed deadlines
- Excellent written and verbal communication skills
- Ability to build relationships at all levels
- Ability to independently work with vendors in resolving issues and developing solutions
- Strong interpersonal skills

- Bachelor of Science or Master degree in Computer Science or Engineering or related discipline

- Strong work organization and prioritization capabilities
- Takes ownership and accountability for assigned work
- Ability to manage multiple activities
- Focused and determined in getting the job done right
- Ability to identify and manage key risks and issues
- Shows drive, integrity, sound judgment, adaptability, creativity, self-awareness and an ability to multitask and prioritize
- Good change management discipline


Please see our complete list of jobs at:

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online