Remote ETL Developer || W2 ONLY

Ford Motor Company-Remote rollSoftware Engineer Senior #983524Location: Remote Visa: NO H1B CPT

Client is looking for a Software Developer to work remotely.Please send the years experience with each highlighted skill in the job descriptionPlease only candidates that have said they can be there day 1 (not in 1-2 months as client has burned with that)

Job Description:· Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization.· Analyzes the impact of changes on existing ETL processes and systems. Assesses the compatibility with goals in all areas.· Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies.· Design, develop and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts.· Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications· Analyzes and resolves problems and provides technical assistance as is necessary. Implements corrective actions.· May prepare or review product documentation, written instructions or technical literature for accuracy and completeness.· Maintenance of business rules associated with data integration.· Participate in the fulfillment of ad-hoc data requests from internal business owners.· Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps. Skills Required:· 5+ years of ETL development experience preferably in Informatica Intelligent Cloud Service (IICS) and SQL Server Integration Services (SSIS).· 5+ years of experience working with basic Linux Server Operations like managing IDs, access, SFTP file transfer operations etc.· 5+ years of experience in SQL Server or any relevant database.· 3+ years of team lead experience.· Experience in designing/implementing APIs/Microservices.· Experience of working under PDO model.· Familiarity with Agile work practices (backlog, scrum ceremonies etc.) and associated tools (Rally etc).· Ability to quickly adapt to changes.· Strong analytical and critical decision-making skills.

Key Skills

• SQL
• Microservices