The purpose of the job is to design and develop ETL solutions for Global Liquidity Reporting System (GLRS). The candidate will be responsible for understanding the requirements, designing, coding and testing along with the development team. This will involve working closely with the business and SMEs to prioritize business requests, manage the Batch Processing development work slate, provide estimate efforts, and ensure timely delivery on committed items and to project manage all aspects of software development according to the Software Development Lifecycle (SDLC).
The Global Liquidity Reporting System (GLRS)
application standardized and consolidated liquidity reporting solution to global treasury users. GLRS application consumes data from GENESIS and ADS/SDRs to produce various liquidity reports for FRB and PRA agencies. GLRS Reports used by Treasury users to analyze firm liquidity status to take internal funding decisions as well as report to external agencies.
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
3 to 8 years of experience in Software development
Expertise in building ETL applications using Ab Initio, ACE or Talend.
Good knowledge of RDBMS Oracle, with ability to write complex SQL needed to investigate and analyse 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
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.
were looking for SQL Engineer/Developer to maintain our Microsoft SQL Server environment and build new ETLs and integrations. The job will require a combination of strong technical skills in data ware [...]
ROLE OVERVIEW : - For Chennai Locations only Immediate Joiners 3-6 years experience - Extensive experience on writing Complex SQL queries, Stored procedures and user-defined functions. - Experience wi [...]
1. Design and Develop Tableau dashboards 2. Write Complex Tableau calculation, LOD Expressions 3. Hands on experience with Tableau version 2019 and latest 4. Must have experience in Dashboard Performa [...]
Requirements : - More than 4 years of experience in developing various SQL database objects such as tables, views, index, functions, stored procedures, and scheduled jobs in MS SQL Server Relational D [...]