• Data Engineering Lead - ETL/Informatica Jobs in Mumbai,India

  • Skillventory
  • Save Job
  • 9 - 15 Years
  • Posted : above 1 month

Job Description:

Overview on Operations Compliance and Technology

- Operations and Compliance Technology (OCT) is looking for a Data Engineering Lead our Mumbai office IMRS Platform is a key component of Enterprise Metrics & Analytics Practice Area within OCT This practice supports Global Operations and Finance Control Group by defining, acquiring, publishing, and analyzing an integrated set of key risk and performance metrics These metrics enable managers to make informed decisions, while executing the Firms objectives across the domains of Risk, Financial and Manpower

- Were a lean, flat and experimental team combining science and engineering to identify and inject high-value insights into Global Operations processes at their point of highest impact

- The successful candidate will work with global teams spread across Bangalore, Mumbai and New York You will get the opportunity to develop new streams, enhance existing streams and work on critical data sourcing aspect of the project

- You will also get the opportunity to work with upstream Technology teams, Report users (Sr management), internal/external vendors, Support teams related to requirement, design, development and user support

The successful candidate will display ownership attitude and will be responsible for

- Providing architectural oversight to the team in implementing best practices across full lifecycle of data (data ingestion, modeling, processing, security, archival/purging, tuning)

- Set the standards for designing, coding, testing, tuning and maintenance of data warehouse / data marts

- Work directly with Modelers/Architects/DBA on data modeling, logical/physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution

- Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions

- Demonstrated on-the-job experience or a thorough understanding of data storage and retrieval technologies, to include relational (SQL) databases, NoSQL databases, Columnar databases

- Delivering projects with a high-level of data quality and integrity

- Meet deadlines and possess a proven record of successful project execution and delivery

- Demonstrate knowledge of SDLC processes and procedures adjusted for a Rapid Application Development methodology (agile)

- Provide support for the resolution of all reporting issues escalated by the Support Operations Team post-implementation

- Working with global development team to have designs implemented, tested, productionalized and present to user groups

- Influencing decisions with divisional partners, internal teams, senior management, and external partners

- Collaborate with the team to define the information architecture, advocating interaction design best practices with a focus on consistency and usability


a Requirements

- The candidate must have strong experience/exposure across the entire data landscape with the ability to extend traditional data architecture techniques This includes Data Strategy and Architecture development, Data Governance, Master Data Management, Metadata management, Data Integration/ingestion, Data Quality management, Data modeling, Data warehousing, Business Intelligence and advanced Analytics

- 8+ years of development experience in DW implementations, data modelling, ETL design and development (Informatica), Physical modeling and performance tuning, enabling self-serve BI/Data analytics

- Experience in any scripting language like perl, shell, python to be used for automating data cleansing, data re-formatting

- Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations

- Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages

- Good knowledge in designing audit / logging metadata for capturing operational metrics (runtime failures, record counts) and integrating with ETL flows for auto recovery, restart ability from point of failure

- Expert knowledge of DB2/Greenplum SQL Stored Procedures, Physical Modeling (partitioning, indexing), Triggers, and data querying optimization

- Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment

- Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models

- Ability to effectively interact with, present information to, and respond to questions from all levels of the organization and partners

- Ability to communicate complex analysis in a clear, precise, and actionable manner

- Comfortable with ambiguity, creative thinking and leading change

- Financial Services experience will be a strong plus

- Exposure to Big data tech stack (Hadoop, MR, Spark, NoSQL) will be a big plus

b Educational Requirements Bachelors/Masters Degree in Engineering, preferably Computer Science/Engineering

Years of Experience 8-12 years of experience in a technology organization

Primary Skills/Must have

1 Extensive knowledge & experience in development & application based troubleshooting

2 Strong knowledge of scripting languages (Shell/Perl/Python)

3 Strong knowledge of SQL

4 Knowledge of developing/supporting complex Informatica mappings

5 Ability to manage multiple deadlines and competing priorities

6 Good knowledge in identifying performance bottlenecks in applications spanning different platforms like scripting, database and informatica mappings

7 Agility to adapt to a rapidly changing environment

Secondary Skills / Desired skills

1 Knowledge of debugging & supporting queries arising from any reporting tools like Cognos, Qlikview or Tableau

2 Knowledge of supporting Java applications

3 Knowledge about Devops implementation in Data space

4 Financial Services experience will be a strong plus

Profile Summary:

Employment Type : Full Time
Salary : Not Mentioned
Deadline : 07th Jan 2020

Key Skills:

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status