Job Description
This requirement to source profiles with 6-9years of overall experience, including minimum of 4years in Data engineering.
Added the below point based on observation
Look for combinations with Informatica, IICS , Python,(If not Informatica we can submit with Talend,) Pyspark, SQL , Step Functions, Lambda & EMR on high level exp -
Location
Hyderabad
Key responsibilities and accountabilities
- Design, build and maintain complex ELT/ETL jobs that deliver business value.
Extract, transform and load data from various sources including databases, APIs, and flat files using IICS or Python/SQL.
- Translate high-level business requirements into technical specs
- Conduct unit testing, integration testing, and system testing of data integration solutions to ensure accuracy and quality
- Ingest data from disparate sources into the data lake and data warehouse
- Cleanse and enrich data and apply adequate data quality controls
- Provide technical expertise and guidance to team members on Informatica IICS/IDMC and data engineering best practices to guide the future development of MassMutuals Data Platform.
- Develop re-usable tools to help streamline the delivery of new projects
- Collaborate closely with other developers and provide mentorship
- Evaluate and recommend tools, technologies, processes and reference
Architectures
- Work in an Agile development environment, attending daily stand-up meetings and delivering incremental improvements
- Participate in code reviews and ensure all solutions are lined to architectural and requirement specifications and provide feedback on code quality, design, and performance
Knowledge, skills and abilities
Please refer Education and Experience
Education and experience
- Bachelors degree in computer science, engineering, or a related field. Masters degree preferred.
- Data: 5+ years of experience with data analytics and data warehousing. Sound knowledge of data warehousing concepts.
- SQL: 5+ years of hands-on experience on SQL and query optimization for data pipelines.
- ELT/ETL: 5+ years of experience in Informatica/ 3+ years of experience in IICS/IDMC
- Migration Experience: Experience Informatica on prem to IICS/IDMC migration
- Cloud: 5+ years experience working in AWS cloud environment
- Python: 5+ years of hands-on experience of development with Python
- Workflow: 4+ years of experience in orchestration and scheduling tools (e.g. Apache Airflow)
- Advanced Data Processing: Experience using data processing technologies such as Apache Spark or Kafka
- Troubleshooting: Experience with troubleshooting and root cause analysis to determine and remediate potential issues
- Communication: Excellent communication, problem-solving and organizational and analytical skills
- Able to work independently and to provide leadership to small teams of developers.
- Reporting: Experience with data reporting (e.g. MicroStrategy, Tableau, Looker) and data cataloging tools (e.g. Alation)
- Experience in Design and Implementation of ETL solutions with effective design and optimized performance, ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms.
Specify the minimum acceptable level of education, experience, certifications necessary for the role
Application Requirements
No special requirements
Support Hours
India GCC US (EST) hours overlap for 2-3 hours
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: Software Development
Role: Data Engineer
Employement Type: Full time
Contact Details:
Company: curious for tomorrow
Location(s): Hyderabad
Keyskills:
Pyspark
Lambada
EMR
Python
sql
Informatica
aws
Talend
etl