ETL Developer

About the job :

Job Summary :
The ETL Developer works within the product development function, and is primarily responsible
for the creation of required data models, smooth functioning of data pipelines and integration
any new dataset, working alongside the technology team and project manager.


Responsibilities and Duties:

● Designing, developing and maintaining ETL processes for the data warehouse; from the
   acquisition and staging of data, storing records within the warehouses historical archive
   and transforming records for loading into the target tables.
● Prepare key documentation to support the technical design in technical specifications.
● Author and execute unit test scripts.
● Contribute in solution design workshops, championing and promoting the application of
   ETL best practice.
● Design and development of the Data Warehouses batch management control processes
   and error handling procedures.
● Analyze the data in the source to look for data quality problems and write code to fix
   data quality issues or create code to log those errors for reporting needs.
● Help the production support team to resolve ETL batch failures.
● Understand and manage the data schema for the application’s data warehouse, taking
   ownership of the creation of new data structures as per application requirements.
● Analyze and design an ETL process.
● Write technical requirements.
● Identify needed destination data structures and propose solutions.
● Review and integrate custom transformations created by other team members.
● Participate in design sessions, code reviews, functional testing and deployments.
● Collaborate with architects, technical designers and other members of the team to
   ensure development is in line with and meets enterprise standards.

● Deep knowledge of data architecture, data warehousing and ETL process design is
   required.
● Extensive knowledge of custom data-driven applications leveraging multiple data
   sources/databases is required.

Knowledge & Skills:

● At least 3-5 years of hands-on experience designing and developing data integration
   solutions is required
● Deep knowledge of data architecture, data warehousing and ETL process design is
   required.
● Thorough knowledge of end-to-end solutions, business process management and SDLC,
   including source control, maintenance and deployments are required.
● Strong working knowledge of SQL is required.

Essential:
    Strong experience in ETL Developer role with hands-on experience in developing complex ETL
processes using Talend / Informatica / Pentaho.


Desirable:
   
Fair experience in ETL using Talend and multiple RDBMS especially PostgreSQL.

Notice: Immediate joiners / 15 days
Job Type: Full-time
Experience: 3+ Years

Upload Resume
Upload File
Max Doc File Size 15MB

Location : 
WeWork, Floor 2B, Room no. 124, K Raheja Platinum, Sag Baug
Road, Off Andheri Kurla Road,Marol, Andheri East, Mumbai 400 059.