ETL Developer

Software Guidance & Assistance, Inc., (SGA), is searching for an ETL Developer for a direct placement assignment with one of our premier financial services clients in Irving, TX.

Responsibilities :

• Will build the team in Canada and work with ETL developers in NAM,EMEA and India(APAC) and will be overseeing the deliverables, provide architectural guidance, enforce best firm practices, conduct code reviews, build support processes, and serve as escalation point during production outages.
• Interaction will be required with global development team comprising of Business Analysts and also work with vendor teams to coordinate and manage deliverables.
• Looking for a manager with 12 years of experience in designing and delivering ETL solutions on Reference Data Team focused on expanding and maintaining firm centralized reference data platform used by Capital Markets division of ICG.
• This is a challenging and exciting opportunity to join a team working for one of the world's largest financial institutions.
• Event Master Central(EMC) and securities reference data are global reference data management application responsible for sourcing securities/Events and pricing data from market vendors and internal firm sources and providing it to downstream clients after applying client specific rules.
• Will have an excellent opportunity to extend their current role and responsibility into Strategic Reference Data initiatives
• Will also get the chance to work with Global tech leads in other project initiative
• Will work with complex and variable issues with substantial potential impact, weighing various alternatives and balancing potentially conflicting needs.
• Will be responsible for building and managing senior and junior ETL developers.
• Work directly with global application development teams, Operations teams/partners to successfully integrate.
• Will work with team and manage deliverables, provide architectural guidance, enforce best firm practices, conduct code reviews, build support processes, and serve as escalation point during production outages.
• Keep up to date with new technologies and their possible adoption within ISG
• Work on streamlining processes and work closely with other team members, onsite and remote to ensure consistent approach to development/process is used within the application.
• Work with vendor teams to Coordinate and manage key projects.

Required Skills:

• Bachelor's or master's degree
• Ab Initio GDE and Co> Op (Continuous, Batch, Plans)
• Data Stage
• UNIX/Linux Shell scripting
• Oracle concepts, SQL, PL/SQL
• SQL performance tuning
• Autosys
• Knowledge and experience of managing reference data sytems.
• Knowledge of Securities and Pricing data.
• Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle
• Strong command of ETL architecture and Tools (Abinitio), and working with relational databases
• Experience of working in a demanding and results driven, time critical environment
• All potential candidates must be able to work in a dynamic team environment which includes working and managing teams on different technologies (such as Java, Web Services and C#/.NET) and across multiple regions
• Requires excellent Interpersonal skills to interact with Business and project management stakeholders globally
• Ability to think Out of the box for any given business requirement
• Act as a change agent to drive innovation

Preferred Skills:

• Data modeling
• Knowledge of advance AbInitio components
• Tibco EMS and other message-oriented middleware
• XML/XSD/XSLT
• Web Services
• Java SE
• Prior industry experience with Reference Data
• Java EE: Servlets, JSP and EJB
• Cobol copybook
• EAI

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.