テクノロジー能力
テクノロジー能力株式会社日立製作所(以下、日立)の米国子会社であるGlobalLogic Inc.(以下、GlobalLogic)は、...
Hitachi iQ, an industry-specific AI infrastructure solution, was launched in Japan in J...
Senior Software Engineer
Engineering
5-10 years
Mexico
ETL, Pipeline Execution/ETL, Python, REST, SQL, SQL Server
Remote
SPP
Qualifications:
● 2-4 years of experience in a data-focused test engineering or data quality role.
● Expert SQL Skills: Proven expertise in writing complex SQL queries, joins, and stored
procedures for data validation, profiling, and integrity checks within a SQL Server
environment.
● ETL & Data Pipeline Testing: Deep experience in testing data transformations and
workflows in a complex data pipeline. Hands-on experience with SQL Server Integration
Services (SSIS) is highly desirable.
● Proficient in Python: Strong Python skills are required for test automation, generating test
data, and validating data via API calls. Experience with Pandas for data manipulation and
pyodbc for database connections is essential.
● API Testing Acumen: Skilled in testing REST APIs to ensure data integrity through service
interfaces. Experience with tools like Postman or scripting API tests with Python’s requests
library is required.
● Strong Analytical Skills: Ability to understand complex data schemas and business rules
and translate them into effective, detailed test plans.
● Clear Communication: Effective at articulating complex data issues to both technical
(engineers, developers) and business stakeholders.
Desirable Plus:
● Familiarity with containerized environments (Docker, Kubernetes/OpenShift) and experience in the energy or utility sector.
Responsibilities:
● You work as a member of a multidisciplinary, global team to ensure the integrity and quality
of mission-critical planning data.
● You will develop data quality solutions by:
● Collaborating with Subject Matter Experts (SMEs) to analyze complex engineering and
operational data requirements and translate them into specific, automatable data quality
rules.
● Creating and managing complex test data sets (e.g., .prj, Excel, CSV files) designed to test
both valid and invalid data submission scenarios.
● Studying the end-to-end systems flow, from file submission to the final gold schema, to
identify and investigate potential data quality issues.
● You will design, build, and maintain an automated testing framework for the data ingestion
pipeline using SQL and Python.
● Design and implement test cases to validate data transformations within SSIS packages
and the Python/Java-based parsing and validation APIs.
● Perform rigorous data validation against the stage and gold database schemas to ensure
data lineage, accuracy, and completeness.
● Participate in code reviews of SQL stored procedures and Python validation scripts to
provide feedback and suggestions that increase quality.
Culture of caring. At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you’ll experience an inclusive culture of acceptance and belonging, where you’ll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders.
Learning and development. We are committed to your continuous learning and development. You’ll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic. With our Career Navigator tool as just one example, GlobalLogic offers a rich array of programs, training curricula, and hands-on opportunities to grow personally and professionally.
Interesting & meaningful work. GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you’ll have the chance to work on projects that matter. Each is a unique opportunity to engage your curiosity and creative problem-solving skills as you help clients reimagine what’s possible and bring new solutions to market. In the process, you’ll have the privilege of working on some of the most cutting-edge and impactful solutions shaping the world today.
Balance and flexibility. We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life. Your life extends beyond the office, and we always do our best to help you integrate and balance the best of work and life, having fun along the way!
High-trust organization. We are a high-trust organization where integrity is key. By joining GlobalLogic, you’re placing your trust in a safe, reliable, and ethical global company. Integrity and trust are a cornerstone of our value proposition to our employees and clients. You will find truthfulness, candor, and integrity in everything we do.
GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.