Data Engineer

Total experience: 5 to 7 Years

Requirements

• 5 to 7 years of experience in ETL and reporting development
• 5 to 7 years of experience with SQL and writing stored procedures
• 5 to 7 years of experience building ETL pipelines
• 5 to 7 years of experience in Snowflake and DB2 databases.
• Strong knowledge of SQL for reporting and data analysis
• Have Worked in Agile, DevOps and Git
• 3-5 years of experience with Python for ETL and report generation
• Perform of data validation and reconciliation.
• Knowledge of reporting tools such as Business Objects or Tableau is good to have.
• Experience in cloud platforms (Azure/GCP/AWS) good to have

Responsibiliti

• esDesign and build scalable ETL pipelines to ingest, transform and load large volumes of OTC derivatives data for downstream reporting and analytic
• s.Develop and optimize database objects, stored procedures and batch processes that support ETL workflows, report generation and data deliver
• y.Design data models, schemas, SQL views and stored procedures to support efficient ETL processing and regulatory, operational and business reportin
• g.Build and maintain real-time and batch ETL pipelines for trade and confirmation data ingestion, transformation, reconciliation and report-ready data provisionin
• g.Support data migration and onboarding activities by building validation routines, reconciliation checks and ETL cutover processes to ensure reporting continuit
• y.Develop, automate and support regulatory and business reports using Python, SQL stored procedures and enterprise reporting platforms such as Business Objects and Tablea
• u.Write complex SQL queries, stored procedures and reusable reporting logic to generate accurate, timely outputs for business users and regulatory consumer
• s.Ensure strong data controls, access governance and quality checks across ETL pipelines, reporting datasets and database environment
• s.Participate in Agile delivery and contribute to automation, scheduling and CI/CD practices for ETL jobs, reporting workflows and production deployment
• s.Provide production support for ETL and reporting processes, including job monitoring, issue triage, data reconciliation and root cause analysi

s.