Data Engineer| Informatica| ETL| AWS

Job Description

Job Description-

For a Data Engineer with skills in Informatica, Data Warehouse - ETL, and AWS, the required skill set typically includes the following:Exp- 8+ years
Location- Mumbai (Andheri East)

1. Informatica

• Proficiency in Informatica PowerCenter, Informatica Cloud, or other relevant Informatica tools.
• Ability to develop and maintain ETL mappings, sessions, and workflows using Informatica.
• Experience in data transformation, cleansing, and validation processes.
• Understanding of Informatica performance tuning techniques to optimize load performance.
• Knowledge of metadata management and data quality tools within the Informatica ecosystem.

2. Data Warehouse & ETL

• Strong understanding of data warehousing concepts like star schema, snowflake schema, dimension tables, and fact tables.
• Proficiency in designing and developing ETL pipelines for data integration.
• Experience with SQL and PL/SQL for querying and managing relational databases.
• Knowledge of data modeling, including dimensional modeling and normalization techniques.
• Ability to manage large-scale data migration projects.

3. AWS (Amazon Web Services)

• Experience with AWS Data Services, including:
  • Amazon Redshift for data warehousing.
  • AWS Glue for ETL jobs.
  • Amazon S3 for data storage and integration.
  • Amazon RDS and Aurora for relational database services.
• Proficiency in AWS Lambda for serverless computing, particularly for data processing.
• Knowledge of IAM (Identity and Access Management) for managing AWS permissions.
• Familiarity with CloudFormation or Terraform for automating infrastructure deployment.
• Experience with monitoring and logging on AWS using CloudWatch or other third-party tools.

4. General Data Engineering Skills

• Strong problem-solving skills and ability to troubleshoot data pipeline issues.
• Knowledge of big data tools like Apache Spark, Hadoop, or Kafka is a plus.
• Familiarity with version control systems like Git.
• Experience with Agile or Scrum development methodologies.
• Understanding of DevOps principles, particularly for CI/CD pipelines involving data engineering processes.

Additional Skills (Optional but Beneficial)

• Python or Java for scripting and automation in data workflows.
• Experience with Docker or Kubernetes for containerizing data applications.
• Knowledge of data governance and data security best practices.

This skill set makes you highly competitive in roles that involve designing and building robust data pipelines, optimizing data warehousing solutions, and integrating AWS cloud services.

Competitive compensation commensurate with role and skill set
Medical Insurance Coverage worth of 10 Lacs
Social Benifits including PF & Gratuity
A fast-paced, growth-oriented environment with the associated (challenges and) rewards
Opportunity to grow and develop your own skills and create your future