StamfordRecruiter Since 2001
the smart solution for Stamford jobs

Data Migration Project Manager- contract to hire

Company: Crossfire Consulting Corporation
Location: Stamford
Posted on: November 25, 2022

Job Description:

JOB SUMMARY
Responsible for developing processes that are required to extract, transform, cleanse and manage data in support of the organization s analytics ecosystem.

MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience. Builds data transformations including importing data from files, moving data from one database platform to another, streaming data including by Kafka and obtaining via REST APIs; as well JSON format. Develops plans and secures resources to support data migration projects. Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements. Gathers business requirements and works with data analysts on physical database design and modeling. Performs code reviews, analyzes execution plans, and re-factors inefficient code. Follows data standards, resolves data issues, completes unit testing and system documentation for Extract Transfer Load (ETL) processes. Write clear and concise functional and technical documentation. Creates technical documentation of design logic and ETL/ELT processes based on technology best practices, guidelines and repeatable processes. Analyzes day-to-day functions and processes that are flexible and scalable to accommodate future business requirements. Perform other duties as assigned.

REQUIRED QUALIFICATIONS


  • Required Skills/Abilities and Knowledge Ability to read, write, speak and understand English In-depth understanding of database fundamentals, including relational database design, multidimensional database design In-depth knowledge of relational databases, as well as expertise in SQL query design and development Languages: SQL, T SQL, PL-SQL Database Expertise: SQL Server 2016, 2014, 2012, MS Access Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server ETL Data Warehouse concepts and tools: SSIS/DTS, BCP, Sqoop Cloud/AWS: Scalable Amazon Relational Database Service (RDS), Hive or Impala
  • In-depth analytical ability and aptitude to derive and translate data designs from business concepts
  • Ability to conduct research into systems issues and products as required Proven creative problem-solving abilities
  • Ability to communicate ideas to technical and non-technical audiences
  • Ability to quickly stage & shape data from data warehouses into reporting and analytics solutions Proficiency with writing T-SQL queries and stored procedures
  • Understanding of & experience in Excel PowerPivot models
  • Ability to meet deadlines in a fast-paced environment
  • Ability to work independently and as a part of a team Effective interpersonal and communication skills (written and verbal).
  • Ability to work with stakeholders to understand reporting needs, design, and implement solutions
  • Expert capabilities with SQL Server, SQL Server Reporting and Analysis Services Effective leadership, time management, facilitation, and organizational skills Reporting: SSRS (SQL Server Reporting Services), Excel, Tableau, Power Pivot
  • Required Education Bachelor's degree in Information Systems or related field, or equivalent combination of work experience
  • Required Related Work Experience and Number of Years Leading data integration projects - 5+

    PREFERRED QUALIFICATIONS


    • Preferred Skills/Abilities and Knowledge Proficiency with generating and consuming RESTful APIs and JSON
    • Understanding of Big Data environments like Hadoop and tools such as Spark and Hive Experience with Pega.
    • Have good knowledge of NoSQL databases like HBase, Cassandra, and MongoDB.
    • Understanding of data workflow/data prep platforms, such as Infomatica, Pentaho, or Talend
    • Understanding of data virtualization concepts and software (Denodo, Teiid, Jboss) Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, VMware

      #Tech

Keywords: Crossfire Consulting Corporation, Stamford , Data Migration Project Manager- contract to hire, Executive , Stamford, Connecticut

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Connecticut jobs by following @recnetCT on Twitter!

Stamford RSS job feeds