• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 25th Oct 2024

• Plan & analyze, develops, maintains, and enhances client systems as well as supports systems of moderate to high complexity.
• Participates in the design, specification, implementation, and maintenance of systems.
• Designs, codes, tests, and documents software programs of moderate complexity as per the requirement specifications.
• Design, develop, and maintain scalable data pipelines using Snowflake, dbt, Snaplogic and ETL tools.
• Participates in design reviews and technical briefings for specific applications.
• Integrate data from various sources, ensuring consistency, accuracy, and reliability.
• Develop and manage ETL/ELT processes to support data warehousing and analytics.
• Assists in preparation of requirement specifications, Analyzing the data, design and develop data driven applications including documenting and revising user procedures and/or manuals.
• Involved with resolution of Medium to severe complexity software development issues that may arise in a production environment.
• Utilize Python for data manipulation, automation, and integration tasks.
• Assemble large, complex data sets that meet functional / non-functional business requirements. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, PostgreSQL, SSIS, T-SQL, PL/SQL
• Work with stakeholders including the Product, Data, Design, Frontend and Backend teams to assist with data-related technical issues and support their data infrastructure needs
• Write complex SQL, T-SQL, PL/SQL queries, stored procedures, functions, cursors in SQL Server and PostgreSQL. Peer review other team members code
• Analyze the long running queries/functions/procures, design and develop performance optimization strategy.
• Create and manage SSIS packages and/or Informatica to perform day to day ETL activities. Use variety of strategies for complex data transformations using an ETL tool
• Perform DBA activities like maintaining the systems health and performance tuning, manage database access, deployments to higher environments, on-call support, shell scripting and python scripting is a plus
• Participate in employing the Continuous Deliver and Continuous Deployment (CI/CD) tools for optimal productivity.
• Collaborate with scrum team members during daily standup and actively engage in sprint refinement, planning, review and retrospective.
• Analyzes, reviews, and alters program to increase operating efficiency or adapt to new requirements.
• Writes documentation to describe program development, logic, coding, and corrections.