ETL Developer (T2)
Chennai
Applications have closed
Guardian
We provide life insurance, disability insurance, dental insurance, and other benefits that help protect people and inspire their well-being.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* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile AWS Data Warehousing DB2 ETL Hadoop Informatica Oracle Python SDLC Security Spark SQL SSIS Testing
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs