JOB DESCRIPTION:

DB Engineer needs Open search Data Pipeline Relational DB expertise
Design build and maintain scalable and secure relational and cloud-based database systems
Migrate data from spreadsheets or third-party sources into databases PostgreSQL MySQL Big Query
Create and maintain automated workflows and scripts for reliable consistent data ingestion
Optimize query performance and indexing to improve data retrieval efficiency
Implement access controls encryption and data security best practices to ensure compliance
Monitor database health and troubleshoot issues proactively using appropriate tools
Collaborate with full stack developers and data researchers to align data architecture with application needs
Uphold data quality through validation rules constraints and referential integrity checks
Keep UpToDate with emerging technologies and propose improvements to data workflows
Leverage tools like Python Pandas SQLAlchemy Py-Drive and version control Git
Support Agile development practices and CICD pipelines where applicable

REQUIRED SKILLS AND EXPERIENCE:

Strong SQL skills and understanding of database design principles normalization indexing relational integrity
Experience with relational databases such as PostgreSQL or MySQL
Working knowledge of Python including data manipulation and scripting eg using Pandas SQLAlchemy
Experience with data migration and ETL processes including integrating data from spreadsheets or external sources
Understanding data security best practices including access control encryption and compliance
Ability to write and maintain import workflows and scripts to automate data ingestion and transformation
Experience with cloud-based databases such as Google Big Query or AWS RDS
Familiarity with cloud services eg AWS Lambda GCP Dataflow and serverless data processing
Exposure to data warehousing tools like Snowflake or Redshift
Experience using monitoring tools such as Prometheus Grafana or the ELK Stack
Good analytical and problem-solving skills with strong attention to details
Team collaboration skills especially with developers and analysts and ability to work independently
Proficiency with version control systems eg Git
Strong communication skills written and verbal.
Skills
Mandatory Skills: SQL, PostgreSQL/MySQL, Python, Pandas, SQLAIchemy, ETL, Data Migration, AWS RDS, Big Query, Data ingestion, Data Flow, AWS Lambda, GIT and (Grafana/ELK Stack)
Job Title: DB Engineer with Open Search, Relational DB.
Location: Minneapolis, MN. (Onsite). (Need Local or nearby candidates)
Duration: FTE or 6 Months C2H.
Other details
Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long-Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.
Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.
LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Please refer the Job description for details