ETL Developer

1 month ago

Chennai, India Guardian Life Full time

Job Description

:Project Planning, Tracking, & Reporting
•Contribute into the initial coding estimates.
•Support the team in project planning activities and in evaluating risks.
•Communicate regularly with the team about development changes, scheduling, and status.

Design
•Understand assigned detailed (LLD) design and do code development

Qualifications:

The major responsibility of this role is to do BI & DWH project implementations using ETL tools – Informatica/ SyncSort, Querying using HIVE, PRESTO, Spark. He/she is responsible for guiding the team and sharing knowledge with them. Candidate will be responsible for successful deployment and support of the code. He/she will be responsible for guiding and mentoring team members and new hires.

Competencies/Skills: Individual Contributor Competencies

Skills:

2-4 years of hands-on and good experience in ETL tools – Informatica Excellent Communication and analytic skills Good Understanding of Data Warehousing and Data Modelling and be able to interpret logical, physical data models, conceptual models, and ER Diagrams. Knowledge of SAFe Agile Methodology Perform hands-on design and development activities for Extract Transform and Load (ETL) tasks using Guardian approved tools like Informatica and adept at performing impact analysis for ETL changes. Perform hands-on development activities using Guardian approved tools like Syncsort components (DMX tasks and jobs, integrating with scheduler), HIVE, HAWQ, Spark SQL, AWS-EMR and perform Unit testing for all deliverables (good to have) Perform hands-on UNIX, PL/SQL development and perform Unit testing for all deliverables Create and maintain Technical documentation for work deliverables including but not limited to Functional specification, Unit Test Plans, Deployment and Migration Documents, Mapping Document, Data Flow Document, Runbooks and Release notes Coordinate and interact with the On-site / Off-shore team to clarify on requirements / issues if any Perform all applicable SDLC activities for the work items assigned including requirement analysis, impact analysis and effort estimations. Perform initial analysis of tasks, perform effort estimations based on Guardian standards, assign and monitor work queues. Provide Review, Testing support and production deployment and post-production (warranty) support for work deliverables Ensure adherence to Guardian Security, Compliance and Development Standards for work deliverables. Co-ordination with the Guardian SME's and participate in knowledge transition sessions Establish, maintain, and enforce ETL design principles, techniques, standards, and best practices Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and provide ongoing support. Resolve any Application defects or Job abends Work closely with other teams – DBA’s, Network, Storage, Scheduling and User Admin to triage issues and resolve job abends Work on creating steady state deliverables and provide clarifications required for timely Production incident resolution and carrying out On Call Level 2 Production support activities for supported applications Self-motivated and ability to work on his/her individual capacity

Technology:

Informatica, SSIS, Syncsort, UNIX, PL/SQL, Querying using HIVE, PRESTO, Spark, understanding of Data Warehousing and Data Modelling, Oracle, SQL Server, DB2, UDB, HADOOP, AWS EMR, Python Informatica Certified preferred

Education and Experience:

Education:B.Tech Computers/MCA

Experience:2 to 4 years in development projects with BI/ DWH background.

Location:

This position can be based in any of the following locations:

Chennai

  • ETL Developer

    3 weeks ago

    Chennai, India Dexian Full time

    ETL DeveloperRelevant Experience: 6-10 yearsLocation: Chennai (Hybrid)Notice Period: Immediate joiner or currently serving notice period less than 30 daysJob Description:6+ years of IT experience in developing high-performance, high-volume software systems for the fixed income financial services industry using Snowflake, Oracle and AWS.Developing complex...

  • ETL Developer

    3 weeks ago

    Chennai, India Dexian Full time

    ETL DeveloperRelevant Experience: 6-10 yearsLocation: Chennai (Hybrid)Notice Period: Immediate joiner or currently serving notice period less than 30 daysJob Description:6+ years of IT experience in developing high-performance, high-volume software systems for the fixed income financial services industry using Snowflake, Oracle and AWS. Developing complex...

  • ETL Developer

    3 weeks ago

    Chennai, India Dexian Full time

    ETL Developer Relevant Experience: 6-10 years Location: Chennai (Hybrid) Notice Period: Immediate joiner or currently serving notice period less than 30 days Job Description: 6+ years of IT experience in developing high-performance, high-volume software systems for the fixed income financial services industry using Snowflake, Oracle and AWS. ...

  • ETL Developer

    3 weeks ago

    Chennai, India Dexian Full time

    ETL DeveloperRelevant Experience: 6-10 yearsLocation: Chennai (Hybrid)Notice Period: Immediate joiner or currently serving notice period less than 30 daysJob Description:6+ years of IT experience in developing high-performance, high-volume software systems for the fixed income financial services industry using Snowflake, Oracle and AWS. Developing complex...

  • Informatica ETL Developer

    2 weeks ago

    chennai, India Alp Consulting Limited Full time

    Informatica ETL Developer Duties & Responsibilities To write an effective informatica ETL developer job description, begin by listing detailed duties, responsibilities and expectations. We have included informatica ETL developer job description templates that you can modify and use. Sample responsibilities for this position include: Perform advanced...

  • Datastage Developer

    4 days ago

    Chennai, India RiskInsight Consulting Pvt Ltd Full time

    About the Role :We are seeking a skilled and experienced ETL Developer to join our team and play a vital role in building and maintaining our data warehouse infrastructure. You will leverage your expertise in IBM DataStage and related technologies to design, develop, and implement efficient data extraction, transformation, and loading (ETL)...

  • Datastage Developer

    4 days ago

    Chennai, Tamil Nadu, India RiskInsight Consulting Pvt Ltd Full time

    About the Role :We are seeking a skilled and experienced ETL Developer to join our team and play a vital role in building and maintaining our data warehouse infrastructure. You will leverage your expertise in IBM DataStage and related technologies to design, develop, and implement efficient data extraction, transformation, and loading (ETL)...

  • Datastage Developer

    3 days ago

    Chennai, India RiskInsight Consulting Pvt Ltd Full time

    About the Role :We are seeking a skilled and experienced ETL Developer to join our team and play a vital role in building and maintaining our data warehouse infrastructure. You will leverage your expertise in IBM DataStage and related technologies to design, develop, and implement efficient data extraction, transformation, and loading (ETL)...

  • ETL Developer

    4 weeks ago

    Chennai, India Guardian Life Full time

    Job Description:Project Planning, Tracking, & Reporting•Contribute into the initial coding estimates.•Support the team in project planning activities and in evaluating risks.•Communicate regularly with the team about development changes, scheduling, and status.Design•Understand assigned detailed (LLD) design and do code developmentQualifications:The...

  • Python ETL developer

    1 month ago

    Chennai, India HTC Global Services Full time

    We are hiring for Python ETL Developer for one of our leading clients in Banking domainYears of Experience - 7+ yearsLocation - Preferred Chennai/Pan IndiaNotice Period - ImmediateProficiency in Python scripting and prior experience working with large datasets in Python.· Experience with Python data processing libraries.· Proficiency in setting up...

  • ETL/Database Developers

    2 weeks ago

    chennai, India Akkodis Full time

    6+ years of IT experience in developing high-performance, high-volume software systems for the fixed income financial services industry using Snowflake, Oracle and AWS Developing complex data models, monitoring, maintaining and tuning in Snowflake & Oracle database . Understanding data pipelines and modern ways of automating data pipeline using cloud based...

  • ETL Developer

    1 week ago

    Chennai, India Beroe Inc Full time

    Job description:Proficient on SQL, PL/SQL scripts: stored procedures, functions, views etc to implement the business logic.Well versed in Enterprise Data Modelling (Dimension & Relational) with a strong understanding of the Data modelling concept like Star-Schema Modelling, Snowflake’s modelling, and fact and dimension tables modelling of data.Hands-on...

  • ▷ (Immediate Start) ETL Developer

    2 weeks ago

    Chennai, India Dexian Full time

    ETL DeveloperRelevant Experience: 6-10 yearsLocation: Chennai (Hybrid)Notice Period: Immediate joiner or currently serving notice period less than 30 daysJob Description:- 6+ years of IT experience in developing high-performance, high-volume software systems for the fixed income financial services industry using Snowflake, Oracle and AWS.- Developing complex...

  • Bi-etl Developer

    4 weeks ago

    Chennai, India Nityo Infotech Full time

    Skill: BI/ETL DeveloperLevel: 0-3 Yrs Location: PunePosition: 13545862CTC: 31296pm Key responsibilities: Strong Spark SQL with DWH experience is must – should be able to explain his application design and defend design decisions on made for his project. • Perform Development & Support activities for Data warehousing domain• Understand High Level...

  • Bi-etl Developer

    1 month ago

    chennai, India Nityo Infotech Full time

    Skill: BI/ETL DeveloperLevel: 0-3 Yrs Location: PunePosition: 13545862CTC: 31296pm Key responsibilities: Strong Spark SQL with DWH experience is must – should be able to explain his application design and defend design decisions on made for his project. • Perform Development & Support activities for Data warehousing domain• Understand High Level...

  • Bi-etl Developer

    1 month ago

    Chennai, India Nityo Infotech Full time

    Skill: BI/ETL DeveloperLevel: 0-3 Yrs Location: PunePosition: 13545862CTC: 31296pm Key responsibilities: Strong Spark SQL with DWH experience is must – should be able to explain his application design and defend design decisions on made for his project. • Perform Development & Support activities for Data warehousing domain• Understand High Level...

  • ETL Developer

    1 week ago

    Chennai, India Beroe Inc Full time

    Job description: Proficient on SQL, PL/SQL scripts: stored procedures, functions, views etc to implement the business logic. Well versed in Enterprise Data Modelling (Dimension & Relational) with a strong understanding of the Data modelling concept like Star-Schema Modelling, Snowflake’s modelling, and fact and dimension tables modelling of data. ...

  • Etl Testing

    1 month ago

    Chennai, India Chaitanya Placement Agency Full time

    **Responsibilities**: - Test Planning: Collaborate with cross-functional teams to develop comprehensive ETL test plans based on project requirements and data integration specifications. - Test Case Design: Design, develop, and execute detailed test cases and scenarios to validate data extraction, transformation, and loading processes within Big Data...

  • ETL Developer

    3 weeks ago

    Chennai, India Dexian Full time

    Abinitio DeveloperExperience: 7-10 yearsRelevant experience: 5+ yearsLocation: ChennaiWork model: HybridNotice period: Immediate or currently serving notice periodSkills: (technical skills)Mandatory skills: Ab Initio, SQL queriesKey Responsibilities:Establish and implement new or revised application systems and programs in coordination with the Technology...

  • ETL Architect

    1 month ago

    chennai, India Corporate Resources Full time

    Job Description We are looking for ETL Architects(Any ETL tools) who has vast experience in ETL. The candidate should possess the below: Expert level of experience in ETL · Nice to have good experience in XML and Webservice transformations · Good understanding on SQL and Stored Procedures ...