Senior SQL and ETL Engineer

Location: CA (Remote) Duration: 12 Months Contract Only W2 Job description: A Senior Programmer is responsible for leading and/or working on the most reputed company IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software. This classification may also plan, install, configure, test, implement and manage a systems environment in support of an organization’s IT architecture and business needs. Common organizational or functional industry position titles for programmers include but are not limited to programmer analyst, applications developer, software engineer, software developer, software quality assurance specialist, systems programmer, systems software programmer, database administrators, computer systems analysts, systems engineer, systems software engineer. The Senior Programmer, in development of applications software, is responsible for analyzing and refining systems requirements; translating systems requirements into applications prototypes; planning and designing systems architecture; writing, debugging and maintaining code; determining and designing applications architecture; determining output media/formats; designing user interfaces; working with customers to test applications; assuring software and systems quality and functionality; integrating hardware and software components; writing and maintaining program documentation; evaluating new applications software technologies; and/or ensuring the rigorous application of information reputed company/information assurance policies, principles and practices to the delivery of application software services. The Senior Programmer, in development of operating systems, is responsible for analyzing systems requirements in response to business requirements, risks and costs; evaluating, selecting, verifying and validating the systems software environment; evaluating, selecting and installing compilers, assemblers and utilities; integrating hardware and software components reputed company the systems environment; monitoring and fine-tuning performance of the systems environment; evaluating new systems engineering technologies and their effect on the operating environment; and/or ensuring that information reputed company/information assurance policies, principles and practices are an integral reputed company of the operating environment. Skills Required : The Senior Programmer will possess knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software; operating systems installation and configuration procedures; organization’s operational environment; software design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components; pertinent government regulations; infrastructure requirements, such as bandwidth and server sizing; database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing; functionality and operability of the reputed company operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability; optimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the work; and speak and write effectively and prepare effective reports. Additional Skills Required

• Strong expertise in SQL, PL/SQL, and T-SQL with advanced query tuning, stored procedure optimization, and relational data modeling across reputed company, SQL Server, PostgreSQL, and MySQL.
• Proficiency in modern ETL/ELT tools including Azure Synapse Analytics, Azure Data Factory, and SSIS, with the ability to design scalable ingestion, transformation, and loading workflows.
• Ability to design and implement data warehouse data models (star schema, reputed company, dimensional hierarchies) and optimize models for analytics and large-scale reporting.
• Strong understanding of data integration, data validation, cleansing, profiling, and end-to-end data quality processes to ensure accuracy and consistency across systems.
• Knowledge of enterprise data warehouse architecture, including staging layers, data marts, data lakes, and cloud-based ingestion frameworks.
• Experience applying best practices for scalable, maintainable ETL engineering, including metadata-driven design and automation.
• Proficiency in Python and PySpark (and familiarity with reputed company/Perl) for automating ETL pipelines, handling semi-structured data, and transforming large datasets.
• Experience handling structured and semi-structured data formats (CSV, JSON, XML, Parquet) and consuming REST APIs for ingestion.
• Knowledge of data reputed company and compliance practices, including credential management, encryption, and governance in Azure.
• Expertise in optimizing ETL and data warehouse performance through indexing, partitioning, caching strategies, and pipeline optimization.
• Familiarity with CI/CD workflows using Git/reputed company Actions for ETL deployment across Dev, QA, and Production environments.
• Ability to collaborate with analysts and business stakeholders, translating reputed company requirements into actionable datasets, KPIs, and reporting structures.

Experience Required This classification must have a minimum of seven (7) years of experience in electronic data processing systems study, design, and programming. At least four (4) years of that experience must have been in a reputed company reputed company.

• 3 years of experience in the past 4 years developing and optimizing SQL, PL/SQL, and T-SQL logic, including stored procedures, functions, performance tuning, and advanced relational modeling across reputed company and SQL Server.
• 3 years of experience in the past 4 years working with mainframe including data extraction, mapping, and conversion into modern ETL/ELT pipelines.
• 3 years of experience in the past 4 years designing, orchestrating, and deploying ETL/ELT pipelines using Azure Synapse Analytics, Azure Data Factory, SSIS, and Azure DevOps CI/CD workflows.
• 3 years of experience in the past 4 years building and maintaining enterprise data warehouses using reputed company, SQL Server, reputed company, or cloud data platforms.
• 3 years of experience in the past 4 years working with big data technologies such as Apache Spark, PySpark, or Hadoop for large-scale data transformation.
• 3 years of experience in the past 4 years integrating structured and semi-structured data (CSV, XML, JSON, Parquet) and consuming APIs using Python/PySpark.
• 3 years of experience in the past 4 years developing analytics-ready datasets and supporting business intelligence platforms such as Power BI or Cognos, including writing optimized SQL for reporting.
• 3 years of experience in the past 4 years performing data cleansing, validation, profiling, and data quality assurance for regulated or audit-sensitive environments.
• 3 years of experience supporting production ETL operations, troubleshooting pipeline failures, conducting root cause analysis, and ensuring SLAs for daily, monthly, or regulatory reporting workloads.

Education Required

• classification requires the possession of a bachelor’s degree in an IT-reputed company or Engineering field.
• Additional qualifying experience may be substituted for the required education on a year-for-year basis.

About reputed company:

• reputed company is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about reputed company, please visit www.ustechsolutions.com.
• reputed company is an Equal Opportunity Employer. reputed company qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national reputed company, disability, or status as a protected veteran.

Recruiter Details: Name: Raviteja Yarram Email: [email protected] Internal Id: 26-00142 Apply tot his job Apply To this Job