Job Summary:
LanceSoft, Inc. is seeking a Sr Data Engineer to be a critical member of their data team. The role involves designing data integration solutions and developing data processing and manipulation systems to deliver business value aligned with the company's objectives.
Responsibilities:
• Provide scoping, estimating, planning, design, development, and support services to a project.
• Identify and develop the technical detail design document.
• Work with developers and business areas to design, configure, deploy, and maintain custom ETL Infrastructure to support project initiatives.
• Design and develop data/batch processing, data manipulation, data mining, and data extraction/transformation/loading (ETL Pipelines) into large data domains.
• Document and present solution alternatives to clients, which support business processes and business objectives.
• Work with business analysts to understand and prioritize user requirements.
• Design, develop, test, and implement application code.
• Follow proper software development lifecycle processes and standards.
• Quality Analysis of the products, responsible for the Defect tracking and Classification.
• Track progress and intervene as needed to eliminate barriers and ensure delivery.
• Resolve or escalate problems and manage risk for both development and production support.
• Coordinate vendors and contractors for specific projects or systems.
• Maintain deep knowledge and awareness of technical & industry best practices and trends, especially in technology & methodologies.
Qualifications:
Required:
• Developer experience specifically focusing on Data Engineering.
• Hands-on experience in Development using Python and PySpark as an ETL tool.
• Experience in AWS services like Glue, Lambda, MSK (Kafka), S3, Step functions, RDS, EKS etc.
• Experience in Databases like Postgres, SQL Server, Oracle, Sybase, etc.
• Experience with SQL database programming, SQL performance tuning, relational model analysis, queries, stored procedures, views, functions, and triggers.
• Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing).
• Knowledge in developing UNIX scripts, Oracle SQL/PL-SQL.
• Experience with data models, data mining, data analysis, and data profiling.
• Experience in working with REST APIs.
• Experience in workload automation tools like Control-M, Autosys, etc.
• Good knowledge of CI/CD DevOps process and tools like GitHub, Jenkins.
• Strong experience with Agile/SCRUM methodology.
• Experience with other ETL tools (DataStage, Informatica, Pentaho, etc.).
• Knowledge in MDM, Data Warehouse, and Data Analytics.
Company:
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele. Founded in 2000, the company is headquartered in Herndon, USA, with a team of 5001-10000 employees. The company is currently Late Stage.