Competencies/Skills: Individual Contributor Competencies
Skills:
Core Technical Skills
-
ETL Development: Informatica (IICS/IDMC), Databricks
-
Database Technologies: PostgreSQL, Oracle, SQL Server, DB2 UDB
-
Big Data & Querying: Spark SQL
-
Programming & Scripting: Python, UNIX
-
Data Engineering: Data Warehousing, Data Modeling
Key Responsibilities
-
Design, develop, and maintain ETL solutions using Informatica (IICS/IDMC), Databricks, and Syncsort.
-
Perform data extraction, transformation, and loading activities for BI and Data Warehouse projects.
-
Conduct impact analysis and provide effort estimations for ETL enhancements and changes.
-
Develop and execute unit test cases for all deliverables.
-
Develop and optimize SQL, PL/SQL, Spark SQL, Hive, and Presto queries.
-
Create and maintain procedures, functions, triggers, constraints, and cursors.
-
Perform query tuning and ETL performance optimization.
-
Interpret and work with conceptual, logical, and physical data models.
-
Design robust ETL architectures focused on data quality, performance, and error handling.
-
Support current-state ("As-Is") architecture and contribute to future-state ("To-Be") architecture design.
-
Evaluate new technologies and conduct proof-of-concepts (POCs).
-
Execute all SDLC phases including requirements analysis, design, development, testing, deployment, and support.
-
Follow SAFe Agile methodology and Guardian development standards.
-
Participate in release planning, deployment, migration, and post-production support.
-
Provide Level-2 production support and on-call support activities.
-
Troubleshoot ETL failures, application defects, and job abends.
-
Coordinate with DBA, Network, Storage, Scheduling, and User Administration teams for issue resolution.
-
Support warranty and stabilization activities after deployment.
Education and Experience:
Education: B.Tech Computers/MCA
Experience: 4 to 6 years in development projects with BI/ DWH background.
This position can be based in any of the following locations:
Gurgaon
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday
