Candidate is required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment
4 years of experience as ETL Lead Analyst in Banking Domain
Thorough understanding of DWH and BI Dashboard Reporting concepts
Understanding of Data Models
Conceptual Logical and Physical Dimensional
Relational Data Model
Design Develop detailed ETL specifications based on business requirements
Analyze functional specifications and assist in designing potential technical solutions
Identifies data sources and works with source system team and data analyst to define data extraction methodologies
Job Title: ETL Developer
Location: Bridgewater, NJ
The ETL developer will be responsible for analyzing the business requirements design develop and implement highly efficient highly scalable ETL processes
Proficient in ETL Informatica
Defines develops documents and maintains Informatica
ETL mappings and need to be well versed in Unix shell scripting
Good knowledge in writing complex queries in Oracle PL SQL
Unit Integration testing activities and assist in User Acceptance Testing
Maintain batch processing jobs and respond to critical production issues communicate well with stakeholders on his her proposal recommendations
Knowledge status risks regarding delivering solution on time Data Analysis Data Profiling
Root Cause Analysis Source to Target Mapping
Should able to understand Data Warehouse architecture and code
Should able to understand Banking system processes and data flow
Can work independently lead and mentor the team
Any prior experience of Basel Implementation or work for Regulatory
Reporting CCAR team is a big plus
What we offer
Your career matters to you and is important to us too. Because your goals and needs are constantly evolving, we offer visibility, leeway and support to help you grow and progress in your career. This approach builds notably on our comprehensive competency framework, our personal development, training and career management programs, and our University innovative and business-focused learning curriculums.
We promote a culture of diversity. We believe working with talented individuals from different backgrounds and points of view is a strategic advantage and an ongoing opportunity. Diversity enriches our creative solutions and adds value for our clients.
With the digital tech sector growing at a rapid pace and women significantly underrepresented in the industry, we are determined to inspire and recruit more women into technology and build diverse teams that reflect the clients we serve.
Our Shared values have been at the heart of the group since our formation. They are honesty, boldness, trust, freedom, team spirit, modesty and fun. These values influence the way we meet client needs while respecting the regulatory requirements of each country in which we operate, and the way we promote ethically sound practices within Capgemini and in our partnerships.
Capgemini is committed to building a workforce of employees with diverse backgrounds and work experiences. We strongly encourage women, veterans and active military service personnel to apply.