ETL SSIS Architect (Remote)

ETL SSIS Architect

JOB DESCRIPTION

Experience: 8 to 10 years

The ETL SSIS Architect will be responsible for Independently design and develop solutions to support reporting, analytic and warehouse needs using the appropriate platform, tools and programming languages on assorted system requests. Ensure newly designed systems run as needed, perform validity check on production output. Conduct impact assessment with business in order and determine high level design and size of effort based on requirements. Evaluates existing applications that could address client requirements and makes recommendations from complex projects. Identifies alternative uses of technologies that will enhance current or anticipated information systems and that support overall corporate and business goals that are appropriately aligned with the enterprise architecture

Required Skills:

• Experienced SSIS Architect, with strong ETL skills, and SQL server/SSIS package experience.
• Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
• Ability to work with Data Architect and Development Lead. 8-10 Years ETL experience primarily in SSIS
• 1+ years of experience in Cloud Technologies (preferably Azure or AWS)
• 5+ years of SQL Server (or comparable database) experience with BI/DW deployments.
• Must have proven experience with STAR and SNOWFLAKE schema techniques.
• Able to turn functional and data mappings into reporting, analytic and warehousing solutions.
• Experience with Microsoft SSAS / SSRS on MS SQL Server
• Advanced level of writing experience stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks
• Ability to create Source to Target (S2T) mappings based on requirements
• Experience writing scripts in Python or C#
• Knowledge of any Big Data implementation.
• Leads multiple projects as a lead developer and delivers consistent results as per client and organizations expectations.
• Should have worked on Offshore - Onshore model and be able to effectively coordinate between the two.
• Must have team management skills
• Excellent communication skills.

Job Types: Full-time, Contract

Pay: $70.00 - $80.00 per hour

Schedule:

• 8 Hour Shift

COVID-19 considerations:
REMOTE OPPORTUNITY DUE TO COVID

Contract Renewal:

• Likely

Work Location:

• Fully Remote

Visa Sponsorship Potentially Available:

• No: Not providing sponsorship for this job