Responsibilities
- Design, develop, maintain, and optimize scalable ETL pipelines, data marts, and data-transformation solutions.
- Build distributed data-processing solutions using Python, PySpark, Spark, Hadoop, Hive, and MapReduce.
- Develop and optimize Oracle SQL queries for extraction, transformation, analysis, and validation.
- Perform development, testing, UAT support, deployment, monitoring, troubleshooting, and post-production support.
- Implement data-quality, validation, reconciliation, completeness, accuracy, and consistency checks.
- Analyze and resolve pipeline failures, data-quality defects, query issues, performance problems, and production incidents.
- Support CI/CD implementation and maintain deployment artifacts, technical documentation, data mappings, test plans, and operational runbooks.
- Collaborate with data, application, testing, operations, business, and cross-functional teams to define requirements and resolve defects.
- Improve pipeline performance, automation, reliability, maintainability, data quality, and resource efficiency.
Requirements
- At least 5 years of professional experience in data engineering, ETL development, data warehousing, big-data engineering, or a related technical role.
- Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related field; equivalent relevant experience may be considered.
- Strong hands-on experience with Python, PySpark, Spark, Pandas, SQL, Oracle SQL, Hadoop, Hive, MapReduce, and SQL and NoSQL databases.
- Experience building data marts, ETL pipelines, data transformations, large-scale data-processing solutions, and data warehouses.
- Experience with data modeling, dimensional modeling, source-to-target mapping, fact tables, dimensions, data quality, reconciliation, and metadata or lineage concepts.
- Experience with Jupyter Notebook, CI/CD pipelines, testing, data validation, production deployment, SDLC activities, and post-production support.
- Experience troubleshooting production data-pipeline failures, query performance issues, data-quality defects, and processing delays.
- Understanding of secure data access, authentication, authorization, least privilege, credential management, encryption, data masking, and controlled data handling.
- Banking or financial-services data experience and enterprise-scale, high-volume, regulated, or business-critical data experience are preferred.
- Familiarity with cloud-based data platforms, workflow orchestration, monitoring, alerting, infrastructure automation, containers, DevOps practices, and data observability is preferred.
- Equivalent combinations of relevant experience, technical training, substantial pipeline implementations, open-source contributions, or demonstrated production outcomes may be considered.
Benefits
- Flexible workplace arrangements, mentoring, internal mobility, and learning and development programs are offered.
- The company promotes an inclusive, equal-opportunity workplace and encourages applications from diverse backgrounds.
Tech Stack
Categories
About Synechron
At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our Synechron Labs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,000+, and has 55 offices in 20 countries within key global markets. For more information on the company, please visit our website:www.synechron.com.