Truelogic is a leading provider of nearshore staff augmentation services, located in New York. Our team of 500 tech talents is driving digital disruption from Latin America to the top projects in U.S. companies. Truelogic has been helping companies of all sizes to achieve their digital transformation goals.
Would you like to make innovation happen? Have you ever dreamed of building Products that impact millions of users? Nice! Then we have a seat for you on our team!
What are you going to do?
You will have the opportunity to work in a forward-thinking and growth-oriented environment, at a health tech with a mission to make prescription medication more affordable.
Occupy a unique position in the market, by providing enterprise solutions to B2B players in the healthcare space and directly to the final consumer.
-
Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution;
-
Implementing Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions;
-
Coordinate with Business Analyst to validate requirements, perform interviews with users and developers;
-
Implementing solutions to integrate external data with inhouse data;
-
Perform tests and validate data flows and prepare ETL processes according to business requirements;
-
Desig and implement a data conversion strategy from legacy to new platforms;
-
Perform design validation, reconciliation and error handling in data load processes;
-
Ability to write complex SQL queries;
-
Optimize SSIS Package execution and SQL execution to optimize data load performance.
Why do we need your skills?
-
You will have a high degree of autonomy. Therefore, you should have 4+ Years hands on experience in using T-Sql / PL-Sql, SSIS tool set;
-
5+ Years of experience in ETL / ELT implementations;
-
Extensive knowledge of BI concepts (ETL, Dimensional Modeling, Data warehouse Design);
-
Understand DB indexes, Partitions and Explain Plans etc;
-
Experience in Migrations, Deployments, Bitbucket integrations;
-
3+ Years of experience in Production Support and Maintenance;
-
3+ Years of experience in Scription (PowerShell or any other);
-
Experience in building monitoring & alerting mechanisms for data pipelines;
-
Working Knowledge in developing Integrations using APIs, such as REST, SOAP, JDBC/ODBC connections;
-
Strong Analytical and Problem-solving skills.
