Nearshore Technology LLC

ETL Developer

Puebla

Responsibilities

•    Partner with business to collect requirements
•    Transform business-oriented functional specifications into detailed technical specifications
•    Create prototypes/ETL specifications based on requirements and analysis of data
•    Work with source system owners to resolve source data issues and refine transformation rules
•    Ensure software flexibility, scalability and reuse. Work with colleagues to promote best practices and standards in design and development
•    Lead unit and string testing. Support system integration and quality assurance testing. Consistently deliver on time and high-quality products
•    Provide integration tool/product expertise related to design, development, testing and deployment
•    Participate in functional design reviews and lead technical design reviews
•    Conduct technical code reviews
•    Design exception handling and controls
•    Participate in DI design of Data Warehouse projects
•    Maintain metadata to ensure consistent metric definitions and nomenclature is used within the EDW/BI environment
•    Create and maintain Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques
•    Design and develop ETL mappings and workflows/sessions
•    Produce detailed technical design documentation to support the solution
•    Support all on-call production support duties
•    Troubleshoot and tune existing applications proactively to maintain high service level standards
•    Act as a liaison to other team members on standards, programming techniques, and other relevant topics
•    Develop and maintain effective relationships through effective and timely communication
•    Prioritize and balance competing priorities

Qualifications

•    3+ years of data warehouse experience
•    4+ years of ETL (Extract, Transform, Load) Programming experience
•    Excellent SQL skills, including writing efficient code, tuning, complex stored procedures

Other skills (Desired)

•    Data modeling experience
•    Ability to effectively assess stakeholder, partner, or client needs while consulting, building solutions, and developing processes
•    Attention to detail and able to effectively handle multiple deadlines in a demanding client driven environment
•    Ability to work with both business and technology partners
•    Excellent written and oral communication skills
•    Deep understanding of ETL and DW concepts and best practices
•    Expertise in SSIS
•    Experience working in an onshore and offshore model
•    Work experience in financial services industry preferred
•    Cloud build experience in Azure preferred

Benefits

  • Relocation Package  
  • Permanent - Full Time Job  
  • Work from Mon through Fri. WE LEAVE EARLY ON FRIDAYS! 
  • Upper MX Law Benefits including Medical Insurance with Dental Discounts 
  • 100% Payroll scheme  
  • Career Path 
  • Cool offices and a collaborative environment  
  • American Company culture  
  • Health & Wellness program for employees