FBS Senior Data Engineer
$312,000,000–$416,000,000 year
HybridPune, Maharashtra, India or Hyderabad, Telangana, India
Job Summary
Design and develop enterprise data warehouse and data mart solutions, including data models, STTMs, technical design documents, and data lineage documentation. Monitor and support ETL/ELT pipelines processing large volumes of enterprise data using Oracle Data Integrator (ODI) and advanced SQL. Analyze and profile data from multiple source systems, including DB2, Oracle, and distributed platforms, while investigating and resolving production issues, data quality concerns, and performance bottlenecks. Collaborate with business partners to translate requirements into scalable data solutions and lead technical discussions on data architecture and integration strategies. Implement data quality controls, reconciliation processes, and governance standards aligned with security and compliance requirements. Support cloud modernization and data migration initiatives with hands-on experience in AWS and Azure.
Required Qualifications
- Strong data analytics and technical skills
- Ability to create data models, STTMs, and other technical documentation
- Strong communication skills
- Ability to understand design requirements and existing business processes
- Ability to lead in the design, development, and implementation of data products
- Ability to collaborate with business partners and data scientists
- Design, develop, monitor, and support ETL/ELT pipelines processing large volumes of enterprise data
- Advanced experience using Oracle Data Integrator (ODI)
- Design and develop enterprise data warehouse and data mart solutions
- Experience creating data models, STTMs, technical design documents, and data lineage documentation
- Analyze and profile data from multiple source systems
- Experience with DB2, Oracle, and distributed data platforms
- Advanced expertise in SQL and Oracle PL/SQL development
- Experience with complex query writing, performance tuning, and optimization
- Strong data modeling experience
- Experience with dimensional modeling using Kimball methodologies
- Experience with Third Normal Form (TNF)
- Experience with Data Vault concepts
- Experience with Medallion Architecture
- Investigate and resolve production issues, data quality concerns, performance bottlenecks, and SLA risks
- Experience with incident management, root cause analysis, and production support
- Collaborate with business partners to translate requirements into scalable data solutions
- Lead technical discussions and provide guidance on data architecture, modeling, and integration strategies
- Experience implementing data quality controls, reconciliation processes, metadata management, and governance standards
- Strong understanding of data security, access controls, PII protection, and compliance
- Support cloud modernization, data migration, and platform transformation initiatives
- Hands-on experience with multiple cloud platforms (AWS, Azure)
- Intermediate - Python development skills for data integration, automation, and analytics
- Intermediate - Snowflake, DBT, and related orchestration/version-control tools (e.g., Fivetran, Airflow, GitHub)
- Oracle
- ODI (Oracle data integration)
- PL-SQL
- GitHub
- Exp in Production Support
Desired Qualifications
- Hands-on experience with multiple cloud platforms (AWS, Azure) preferred
- Intermediate - Snowflake, DBT, and related orchestration/version-control tools (e.g., Fivetran, Airflow, GitHub) is a plus
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.