Description

You will design and implement scalable data architectures across distributed environments.

Responsibilities

• Design data modeling frameworks using Data Vault 2.0, Star, or Snowflake models.
• Build and manage ETL/ELT pipelines for Datawarehouse and Datalake platforms.
• Develop complex SQL scripting including SCD1, SCD2, and SCD3 logic.
• Implement Infrastructure as Code using Terraform or CloudFormation.
• Collaborate within cross-functional teams using Agile and Scrum methodologies.

Required Skills

• 12+ years of total professional experience.
• 8+ years with Datawarehouse, Datalake ETL platforms, and SQL scripting.
• 8+ years with Data Modeling frameworks (Data Vault 2.0, Star, Snowflake).
• 8+ years with relational databases (Oracle, SQL Server, DB2, PostgreSQL, MySQL, or SAP Hana).
• 5+ years with AWS services (Glue, Athena, EMR, Firehose, Kinesis, Redshift, RDS, DMS, S3, App Flow, SQS, Lambda, Airflow, Eventbridge).
• 5+ years with NoSQL solutions (DynamoDB, Big Table, MongoDB, Cassandra).
• 5+ years with Python, Java, or Scala.
• 5+ years with Business Intelligence tools (PowerBI, Tableau, QuickSight).
• 5+ years with CI/CD pipelines (GitHub, Azure DevOps).
• 3+ years with Infrastructure as Code (Terraform, CloudFormation).
• Expertise in distributed processing (Spark, Storm, Flink) and Big Data ingestion (Sqoop, Flume, NiFi, Kafka, Pulsar, Pub/Sub).
• Experience with Hadoop ecosystem and AWS Foundation/Organizations.

Preferred Skills

• Experience with work management tools like JIRA, Confluence, or ADO.

Key Skills

Education

Any Graduate